Skip navigation links

MySQL Forums :: Performance :: Simple Query takes 50 seconds with Indexing


Advanced Search

Re: Simple Query takes 50 seconds with Indexing
Posted by: Peter Brawley ()
Date: July 21, 2011 11:34AM

The diff seems to lie in whether the engine needs to hit the data file for values.

1. Consider ...

- changing covering indexes to using short left substrings of varchar fields

- adding covering indexes for frequent queries

2. How much RAM is available to MySQL?

PB

Options: ReplyQuote


Subject Views Written By Posted
Simple Query takes 50 seconds with Indexing 1197 Joms Calma 07/21/2011 08:26AM
Re: Simple Query takes 50 seconds with Indexing 545 Peter Brawley 07/21/2011 11:34AM
Re: Simple Query takes 50 seconds with Indexing 502 Rick James 07/21/2011 10:04PM
Re: Simple Query takes 50 seconds with Indexing 531 Joms Calma 07/22/2011 11:01PM


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.