MySQL Forums
Forum List  »  Optimizer & Parser

Re: querying time is too high
Posted by: Jim Daemon
Date: June 28, 2006 10:00AM

Can you provide the table structure of the usr_tbl table along with the output of EXPLAIN?

Have you tried running OPTIMIZE and ANALYZE on the table before running the query?

Since you are doing a GROUP BY what is the size of your sort_buffer_size variable?

Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a person does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses their intelligence.

Options: ReplyQuote


Subject
Views
Written By
Posted
2512
June 27, 2006 07:31AM
Re: querying time is too high
1692
June 28, 2006 10:00AM
1608
June 29, 2006 12:48AM
1632
June 29, 2006 08:52AM


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.