Re: Dummies guide to fast inserts ?
Date: Thu, 14 Aug 2003 09:52:09 +0100
Message-ID: <bhfimj$ma1$1_at_news.icl.se>
"Richard Shea" <richardshea_at_fastmail.fm> wrote in message
news:282f826a.0308131623.69207485_at_posting.google.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.
If you know the data is good, or can afford to take the risk, then remove constraints on the table, referential and validation. Received on Thu Aug 14 2003 - 10:52:09 CEST