If anybody now how to do optimize MySQL tables in such hard terms - please answer.I'm open to suggestions and ideas here. I've been having this very same problem.
http://dev.mysql.com/doc/refman/4.1/en/merge-storage-engine.htmlBig RDBMS (Sybase, Oracle) have advanced table partitioning features, which help me to store more than 100Gb in one Oracle table.
-- Regards, Eugene Prokopiev
