Dummies guide to fast inserts ?

Hi - I'm interested in creating a table into which I can insert rows with as little overhead as possible. Could the group suggest key points to cover to do this as well as possible ? Just off the top of my head I'm thinking ...

+ No indexing
+ Some sort of restriction on the choice of column types
+ As little data as possible per row
+ Table in own tablespace
 

... however I'm sure there are plenty of other more sophisticated choices (and maybe the ones I've suggested are not significant ?).

Any suggestions would be welcome.

Just for background it's on Win32 and I'm replacing a diagnostic logfile which was previously implemented as an ASCII flatfile.

Regards

Richard. Received on Thu Aug 14 2003 - 02:23:31 CEST