[RADIATOR] AccountingTable Database Very big

[sergio]

I use mysql database, elterei from MyISAM to InnoDB but I wonder if another database would not help.

Very good idea to use your tables YEAR-MES. What database do you use?

you have some script to extract such data in the Browser?

Thanks

> -----Original Message-----
> From: ringo at vianet.ca
> Sent: Sat, 29 Jun 2013 14:02:27 -0400
> To: sergio at inbox.com
> Subject: Re: [RADIATOR] AccountingTable Database Very big
> 
> 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

____________________________________________________________
FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop!
Check it out at http://www.inbox.com/earth