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: Reply•Quote


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


Sorry, you can't reply to this topic. It has been closed.
powered by phorum

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.