MySQL Forums
Forum List  »  Performance

Re: Large Database, Slow Query, need help
Posted by: Benoit St-Jean
Date: September 22, 2005 06:44PM

Kurt Schell wrote:
> I'm currently developing a web application with a
> large database backend. Think multiple 1million+
> row tables.
>
> I think I've done all that I know how to do to get
> the queries and tables optimized (indexes,
> splitting up larger tables into smaller logical
> tables), and most of the queries complete very
> quickly (< 1 second). But, there is 1 query
> that is taking up to 10 seconds to run the first
> time it runs, and then each additional time in
> runs for the same "category" it runs lightning
> fast. However, if you come back to the category
> after much time has gone by, it will again require
> a 10 second first run before additional runs will
> be fast again. I'm assuming it's because of the
> query caching, which is fine. I just want to cut
> the runtime down for the first run to below 1
> second so that it will be fast whether it's cached
> or not.
>
> If someone believes they can assist with this
> problem, and do so in a professional manner,
> please let me know, I'd be willing to pay for a
> solution.
>
> Thanks,
>
> Kurt


Well, more details on the tables involved, the indexes on those tables, the EXPLAIN of the query and your settings would help!

Options: ReplyQuote


Subject
Views
Written By
Posted
7633
September 22, 2005 04:40PM
Re: Large Database, Slow Query, need help
3457
September 22, 2005 06:44PM
3279
September 22, 2005 06:52PM
2558
September 22, 2005 07:11PM
2612
September 22, 2005 07:46PM
6670
September 22, 2005 08:44PM
3079
September 22, 2005 08:57PM


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.