Re: copy of SAP COPA
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.
Subject
Views
Written By
Posted
6957
March 24, 2008 02:06AM
2801
March 24, 2008 07:42AM
Re: copy of SAP COPA
2980
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.