Subject | Re: [firebird-support] Isertion time grows linearly with database size |
---|---|
Author | Anderson Farias |
Post date | 2009-08-17T16:26:24Z |
Hi,
look at page buffers.
insert?
Regards,
Anderson
> I do not start an explicit transaction, so I am assuming that JaybirdNo transaction is not an option with Firebird
> inserts each row in a separate transaction or no transaction at all.
> I am running with default database configuration. Where can I check howgstat -h your_database
> many buffer pages are set up for the database?
look at page buffers.
> Here is performance test trace.is this tests only executing INSERTS or are you SELECTing from table before
> 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
insert?
Regards,
Anderson