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 [EMAIL PROTECTED] 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. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
