[RADIATOR] AccountingTable Database Very big

[Michael]

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 at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator