I use monthly tables. that really helped. Then use the year-month attributes in your insert statements. And of course anything that reads this data will have to be altered to support year-month tables. Also an external process that runs monthly to make sure that the tables get created ahead of time.
On 28/06/13 10:08 PM, sergio wrote: > Hello list > > I use mysql database and my AccountingTable has more than 40 million records > per month. Does anyone here have any policy purge? I have an extract of CGI > access for my users and is very slow because the bank is getting too big. > Does anyone have any recommendation what I should do to have a page extract > access working well with a huge amount of data like this? > > Regards! > > ____________________________________________________________ > GET FREE SMILEYS FOR YOUR IM& EMAIL - Learn more at > http://www.inbox.com/smileys > Works with AIM®, MSN® Messenger, Yahoo!® Messenger, ICQ®, Google Talk™ and > most webmails > > > _______________________________________________ > radiator mailing list > radiator@open.com.au > http://www.open.com.au/mailman/listinfo/radiator _______________________________________________ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator