"Richard Shea" <ri*********@fastmail.fmwrote in message
news:28**************************@posting.google.c om...
Hi - I'm interested in creating a table into which I can insert rowsIf you know the data is good, or can afford to take the risk, then remove
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.
constraints on the table, referential and validation.