MySQL Forums
Forum List  »  Optimizer & Parser

Re: Large database
Posted by: Omar Khan
Date: February 14, 2007 06:55AM

I have added multi row indexes to some of the fields, that increased the speed of view records. But problem remains there for our summary pages(showing some trends, some top values and counts) which contains several queries like,

count(event_id) from xyz where field='value' group by field;
select count(event_id) as c, field, field2,f ield3 from xyz group by count limit 10;
etc

I dont know how can i apply indexing affectively for the queries that includes count. Any idea?

Options: ReplyQuote


Subject
Views
Written By
Posted
3345
January 12, 2007 07:45AM
2100
February 09, 2007 01:42AM
Re: Large database
1934
February 14, 2007 06:55AM
2157
February 14, 2007 06:47PM
2051
February 15, 2007 05:35AM
2164
February 15, 2007 05:13PM


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.