|Subject||Re: [IB-Architect] Insert Speed|
David Schnepper <dschnepper@...> wrote:
>Changing topic slightly --600K
>Deej & I, a few years ago, took a customer's complaint regarding insert
>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.