Re: slow selects
Posted by:
Toa Sty
Date: September 01, 2006 03:04AM
Thanks for the extra info. If your query speed degrades that much as the number of rows in your table increases your queries are probably not using indexes as well as they could.
Can you run EXPLAIN SELECT on your queries and post the output please?
( See:
http://dev.mysql.com/doc/refman/5.0/en/explain.html )
From the figures you've given and the hardware you have I can't see a problem getting the speed you need assuming the queries can be optimised.
Toasty
Subject
Views
Written By
Posted
2721
August 31, 2006 08:02AM
1860
August 31, 2006 08:43AM
1864
August 31, 2006 09:06AM
Re: slow selects
1875
September 01, 2006 03:04AM
1825
September 01, 2006 04:17AM
2094
September 01, 2006 04:50AM
1836
September 01, 2006 07:24AM
1876
September 01, 2006 08:16AM
1870
September 02, 2006 12:52PM
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.