Re: Index performance
"with SQL_NO_CACHE, first execution 75 seconds. Second - 0.2 seconds." -- this is encouraging in one way. After you have warmed up the cache, the queries should run fast, even those that don't use the Query cache. Do you shutdown mysql ever? If you do, consider running some queries after startup to warm up cache.
3 summary tables:
Customer + day
Provider + day
Product + day
Yearly and monthly queries are simply the sum of the sums, sum of counts, and AVERGE = (sum of sums / sum of counts). For that matter a queries over a week or a quarter are essentially as easy, and as fast.
Subject
Views
Written By
Posted
4388
June 15, 2010 08:30AM
1252
June 16, 2010 09:54AM
1363
June 16, 2010 12:03PM
1498
June 16, 2010 08:47PM
1399
June 20, 2010 02:30PM
1233
June 20, 2010 11:05PM
1539
June 21, 2010 07:35AM
1195
June 21, 2010 09:21AM
1211
June 21, 2010 10:31AM
Re: Index performance
1329
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.