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: ri...@vianet.ca > Sent: Sat, 29 Jun 2013 14:02:27 -0400 > To: ser...@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@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 _______________________________________________ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator
