OK, thanks for the help! > -----Original Message----- > From: ri...@vianet.ca > Sent: Sun, 30 Jun 2013 23:59:02 -0400 > To: ser...@inbox.com > Subject: Re: [RADIATOR] AccountingTable Database Very big > > 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 >> >> >> >>
____________________________________________________________ TRY FREE IM TOOLPACK at http://www.imtoolpack.com/default.aspx?rc=if5 Capture screenshots, upload images, edit and send them to your friends through IMs, post on Twitter®, Facebook®, MySpace™, LinkedIn® – FAST! _______________________________________________ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator
