Subject | Re: [IB-Architect] Insert Speed |
---|---|
Author | Jan Mikkelsen |
Post date | 2000-04-07T22:48:34Z |
David Schnepper <dschnepper@...> wrote:
Jan Mikkelsen
janm@...
>Changing topic slightly --600K
>
>Deej & I, a few years ago, took a customer's complaint regarding insert
>speed and
>did some benchmarking. We did find a significant slowdown occur around
>Has anything other than page at a time allocation ever been considered?
>records (no indices, no triggers, no BDE, commit around every 1K records,
>using direct inserts via a Gpre program (so no DSQL)). We didn't take it
>any further -- our best guess was it had something to do with traversing
>the page list looking for free slots.
Jan Mikkelsen
janm@...