Subject Re: [firebird-support] Isertion time grows linearly with database size
Author Anderson Farias
Hi,


> I do not start an explicit transaction, so I am assuming that Jaybird
> inserts each row in a separate transaction or no transaction at all.

No transaction is not an option with Firebird


> I am running with default database configuration. Where can I check how
> many buffer pages are set up for the database?

gstat -h your_database

look at page buffers.


> Here is performance test trace.
> Test Trace Firebird (ms.)
> Inserting 1000 rows in the database with 1000 rows took 2188
> Inserting 1000 rows in the database with 2000 rows took 3078

is this tests only executing INSERTS or are you SELECTing from table before
insert?

Regards,
Anderson