MySQL Forums
Forum List  »  Partitioning

Re: copy of SAP COPA
Posted by: Lars Johansson
Date: March 24, 2008 10:12AM

Thank you.
Reporting is mainly for scorecards rolling 12 months/periods.
Almost every query will select or range period. Current period will be heavily accessed, and the last 13th will be frequently accessed. Periods two years old or older will not be accessed much, so larger partitions for older data is something I try.
I just blow the mysql instance on 'out of disk space condition', so I have to buy more disks before I proceed testing. :)

p.s.
I really really miss parallel processing, I hope it is in the development plans.

Options: ReplyQuote


Subject
Views
Written By
Posted
6953
March 24, 2008 02:06AM
2800
March 24, 2008 07:42AM
Re: copy of SAP COPA
2975
March 24, 2008 10:12AM


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.