[RADIATOR] AccountingTable Database Very big

[sergio]

OK, thanks for the help!

> -----Original Message-----
> From: ringo at vianet.ca
> Sent: Sun, 30 Jun 2013 23:59:02 -0400
> To: sergio at 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: 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
>> 
>> 
>> 
>>

____________________________________________________________
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!