"Richard Shea" <richardshea@fa stmail.fmwrote in message
news:282f826a.0 308131623.69207 485@posting.goo gle.com...
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.
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.