Hi,
is mysql the right kind of database for:
1) trying to add ~1 000 000 tiny rows per day (each row about 100 bytes of data, about 20 bytes key)
2) adding only those rows which were not previously added on the same day (some kind of UNIQUE index), leaving about 100 000 unique records per day
3) selecting sum of DISTINCT rows for week, month, year once per hour, using WITH ROLLUP feature available in 4.1?
All this on single-cpu x86 with 1Gb RAM and 15k rpm SCSI drive.
What kind of storage backend should I use? Does it make sense to hold data for at least one day in RAM?
Best Wishes, Viktors
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
