I've been watching the group for a long time, and there is a huge debate
about MyISAM vs InnoDB for "large" tables.
It really does depend on what you want to use your table for, what hardware
you running on, and what size you consider to be large!
For me, I also have mainly numerical data, and 1-
welcome to the joys of being a DBA ... :)
That's why restorable backups, tst and dev environments are so so important.
And yes, this kind of thing has kept me (and many others) busy more than once
after a too speedily executed SQL statement.
regards
Rob
-Original Message-
From: Dave Dyer