Subject | Re: [firebird-support] Isertion time grows linearly with database size |
---|---|
Author | Dmitry Yemanov |
Post date | 2009-08-17T15:50:10Z |
Alec Lebedev wrote:
What FB version? How many buffer pages are set up for this database?
Do you insert in a single transaction or in multiple ones?
Dmitry
> I have been running performance tests on Firebird and noticed that the time it takes to insert a record in a table grows linearly with the size of the database. The table structure is very simple and has a primary key and no other indexes.With the size of the *database* or the *table* you insert into?
What FB version? How many buffer pages are set up for this database?
Do you insert in a single transaction or in multiple ones?
Dmitry