MySQL Forums
Forum List  »  Performance

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
Re: Simple Query takes 50 seconds with Indexing
795
July 21, 2011 11:34AM


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.