MySQL Forums
Forum List  »  MyISAM

Re: Select query too slow from merge table of 1 billion records
Posted by: Manik Dhawan
Date: February 24, 2010 07:13PM

Bingo..You got it right..It is indeed a Data Warehouse application.
It has got two parts.

1) Aggregates (AVG, SUM, MAX) to which we absolutely have no issues. They do not have any performance problem as the data is aggregated.
2) Searches which are becoming real pain now as we have more than 1 billion records in database currently.

We have got a search screen to search records based on 1 or 2 or 3 or 4 or 5 combinations of input fields of which c_end_datetime will always be entered.

Now, creating so many combined keys would not make sense and so, as of now I don't have any option to speed up these searches.

Will appreciate any pointers.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Select query too slow from merge table of 1 billion records
3373
February 24, 2010 07: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.