[rtg] rated, new version of rtgpoll

[Brandon Ewing]

On Mon, Mar 16, 2009 at 04:15:07PM -0700, Matt Simerson wrote:
> Data segregation is a much better solution. Create a new bandwidth table 
> for each billing interval (typically months) so that every months bandwidth 
> data in it's own table. If you are using MySQL, you can convert previous 
> months data to MyISAM compressed for a far more significant reduction in 
> disk space. The bandwidth queries for generating graphs will be much faster 
> too, as the amount of data in each table would be much smaller.
>
> Matt
>

Couldn't this also be accomplished by setting up horizontal partitions on
your single table?  This would allow the current reporting scripts the
ability to access the data without having to re-write them to support the
multi-table data format.

-- 
Brandon Ewing                                        (nicotine at warningg.com)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.grdata.com/pipermail/rtg/attachments/20090324/71c5a1b6/attachment.pgp>