slow queries
Posted by:
Tess Lomax
Date: March 23, 2005 06:13PM
I had a working web page that queried 20 tables and returned the data in the form of a table ... all of a sudden this stopped returning the results , and on investigation, up to ten tables, the query time is about 0.01 second ... but as the number of tables is increased to fifteen, the query time increases to 60 second .. and then gets too slow with nothing being returned at all.
A few days ago, this was all working fine. There have been no changes to the code on the web page ....
The version of mysql is 4.0.20, the server is a dual 1 MHz Xeon with 512 meg of RAM, running linux.
The tables have up to 15 fields each, and there is only simple text or numerical values in the fields.
Can anyone suggest what might have changed to suddenly slow down the query ?
regards
Subject
Written By
Posted
slow queries
March 23, 2005 06:13PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.