i use mysql. no i don't have anything that reads the data with a browser. sorry.
On 30/06/13 11:33 PM, sergio wrote: > 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
