Subject Re: [IB-Architect] Insert Speed
Author Jan Mikkelsen
David Schnepper <dschnepper@...> wrote:
>Changing topic slightly --
>
>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
600K
>
>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.


Has anything other than page at a time allocation ever been considered?

Jan Mikkelsen
janm@...