Hi there ! A sample create table SQL query is as follows : "create table eml.adjacency select * from emlbase.adjacency where eml.adjacency.importdate = '2002-10-10';"
The database names (e.g. "eml") ,tablenames (e.g. "adjacency") and date are changed by a perl script for the different tables concerned. For the concerned "adjacency" table : it contains about 900000 rows of info for 4 weeks of data. The size is about 220 Mb - not compressed. When doing a promote using the above specified syntax the promoted "adjacency" table contains about 32000 rows of data...the size growing to about 650 Mb !! After running myisampack, the compression ratio is about 95 % We are using 3.23.51-nt on Win2K server. Hope this info helps... --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
