Skip navigation links

MySQL Forums :: Optimizer & Parser :: querying time is too high


Advanced Search

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
querying time is too high 2098 trinath somanchi 06/27/2006 07:31AM
Re: querying time is too high 1489 Jim Daemon 06/28/2006 10:00AM
Re: querying time is too high 1393 trinath somanchi 06/29/2006 12:48AM
Re: querying time is too high 1444 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.