At 01:21 PM 9/3/2000 -0500, Paul Gallagher wrote:

>...
>Basically, I just inserted 10,000 records with a TIB_DSQL component, with
>one user, and checked for time.
>
>The time averaged about 2.95, with a best of 2.85 seconds to insert the
>10,000 rows. Thats 207,000 rows per minute.

...

> Changing buffers to 5000, made no difference.

Additional buffers don't help inserts unless you've got a lot
of indexes and are inserting rows in something other than index
order, or have lots of foreign keys and cross-table constraints.

Ann