MySQL Forums
Forum List  »  Performance

Re: Index performance
Posted by: Alex Vilner
Date: June 21, 2010 10:31AM

Rick,

Thanks again for staying with this. My thoughts were exactly the same. 7192 IDs, times 10 (rows per unique ID) for simplicity sake - 71920 hits. That makes it 10 times your number, or 71920 / 600 = 119.

Anyway, with SQL_NO_CACHE, first execution 75 seconds. Second - 0.2 seconds.

Summary tables.... Argh... The problem is that the types of queries are too wide spread. We have selection conditions slicing and dicing the data:
1. By Customer ID (or customer ID List)
2. By Provider (or provider list)
3. By Year
4. By Year and Month
5. By specific product version

... So it is not as simple as saying: sum everything up for a customer per day :)



Edited 1 time(s). Last edit at 06/21/2010 10:33AM by Alex Vilner.

Options: ReplyQuote


Subject
Views
Written By
Posted
4372
June 15, 2010 08:30AM
1250
June 16, 2010 09:54AM
1360
June 16, 2010 12:03PM
1496
June 16, 2010 08:47PM
1397
June 20, 2010 02:30PM
1229
June 20, 2010 11:05PM
1534
June 21, 2010 07:35AM
1194
June 21, 2010 09:21AM
Re: Index performance
1204
June 21, 2010 10:31AM
1324
June 21, 2010 06:43PM
1514
June 21, 2010 06:55PM


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.