Re: Database design

Thank you very much for your reply. I'm doing a research on performance evaluation of three open source library managment systems (Koha, PhpMyLibrary, OpenBiblio) based on their response times. Response time is taken from the time the query is executed up to the time the retrieved records reach the client. I think these three library management systems have different response times since they differ in database schema, indexing, data types, etc. although they are using the same database which is MySQL. I did some preliminary tests and indeed they have different response times. OpenBiblio has the fastest response time while PhpMyLibrary has the slowest.

Im looking for other literature, the same study as mine, if there are, so that I could enhance my methodology, particularly on how to evaluate their database schema base on their response times. Or maybe any literatures that relates response time and database schema.

I hope this reply helps

Thank you

Archie Received on Thu Apr 06 2006 - 08:09:26 CDT