Slow query response times
Posted: Tue Jul 02, 2002 11:57 pm
I am having trouble with some queries that are becoming painfully slower as my database increases.
I am running MYSql 3.23.38 and have a total of 32 tables in my db, with some 5meg of data contained therein.
I run a main table (with 38 columns) and link to other tables when required via common keys.
I am operatinga Pentium III 450 with 128 mb ram as a server. Apache is my choice of webserver.
Whilst this setup is obviously not the best money can by, it is the best I have to work with and is still a fairly reasonable system.
My problem (as stated earlier) revolves around response speed. The main search query is taking between 10 and 30 seconds to get a response posted. This is unacceptable and is getting worse. If you believe all you read MYSql should be faster than this so its obviously something Im doing.
I have posted a copy of the query on the PHP page (this site) but have had no responses as yet.
Can anyone give me any suggestions as to what might be the problem here - or at the very least where to go ? (Be nice now!)
Yours in frustration
Hebbs
I am running MYSql 3.23.38 and have a total of 32 tables in my db, with some 5meg of data contained therein.
I run a main table (with 38 columns) and link to other tables when required via common keys.
I am operatinga Pentium III 450 with 128 mb ram as a server. Apache is my choice of webserver.
Whilst this setup is obviously not the best money can by, it is the best I have to work with and is still a fairly reasonable system.
My problem (as stated earlier) revolves around response speed. The main search query is taking between 10 and 30 seconds to get a response posted. This is unacceptable and is getting worse. If you believe all you read MYSql should be faster than this so its obviously something Im doing.
I have posted a copy of the query on the PHP page (this site) but have had no responses as yet.
Can anyone give me any suggestions as to what might be the problem here - or at the very least where to go ? (Be nice now!)
Yours in frustration
Hebbs