do you have a trigger to populate the primary key that does "select
count(*)" to find the next value

2009/8/17 Dmitry Yemanov <dimitr@...>:

> Alec Lebedev wrote:
>
>> 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
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu.  Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>