Yves Goergen wrote:
On 28.05.2007 09:06 CE(S)T, Kevin Hunter wrote:
At 12:31a -0400 on 28 May 2007, Dan Nelson wrote:
You want the ARCHIVE storage engine.
http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html
Hm, it doesn't support deleting rows and it cannot use indexes. So doing
statistics on them (which can be a little more complex than counting
rows within a timespan, which is why I wanted to use an SQL database)
could get quite resource demanding.
Another option might be to use compressed MyISAM tables, which you create with
myisampack. Suppose you create a new table every day, and after you start
inserting into the new table, you compress yesterday's file. Then you could use
the MERGE storage engine to provide a view over all the tables as though they
are one.
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
