MySQL Forums :: Optimizer & Parser :: querying time is too high
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.
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.
| Subject | Views | Written By | Posted |
|---|---|---|---|
| querying time is too high | 1930 | trinath somanchi | 06/27/2006 07:31AM |
| Re: querying time is too high | 1398 | Jim Daemon | 06/28/2006 10:00AM |
| Re: querying time is too high | 1333 | trinath somanchi | 06/29/2006 12:48AM |
| Re: querying time is too high | 1373 | Anthony Willard | 06/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.
© 2013, Oracle Corporation and/or its affiliates