Re: Solution to slow queries

[Eric Jensen]

We did something similar for our large statistic tables.  The older data
that no longer changes would get shipped off into a very fast read only
table with a cron job and then that is the table we would generate the
reports on.  Even with millions of entries it is incredibly fast.

Eric Jensen

TheRefUmp@stripped wrote:

>Consider compressing the tables (Making them READ ONLY) with the MyISAM engine. The
> updating table (current one) would not be available since it could not be compressed. 
>  
>