Subject Re: [firebird-support] One table taking a long time to insert/update
Author Douglas Tosi
On Wed, Jun 25, 2008 at 3:53 AM, robertgilland
<robert.gilland@...> wrote:
> We are using firebird 2.03.
> We are finding the below table to take a long time to update/insert.
> ie. 25 minutes for 8000 records inserting.

Do you have many indices on this table?
Maybe forced writes are on and your disk subsystem is slow?
Are you also inserting blobs?
Are you commiting after every insert?

Can you post the table structure and the result of "gstat -h"?

Douglas Tosi