[RADIATOR] AccountingTable Database Very big

[Michael]

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