Subject | Re: [firebird-support] One table taking a long time to insert/update |
---|---|
Author | Douglas Tosi |
Post date | 2008-06-25T12:00:23Z |
On Wed, Jun 25, 2008 at 3:53 AM, robertgilland
<robert.gilland@...> wrote:
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"?
[]s
Douglas Tosi
<robert.gilland@...> wrote:
> We are using firebird 2.03.Do you have many indices on this table?
> We are finding the below table to take a long time to update/insert.
> ie. 25 minutes for 8000 records inserting.
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"?
[]s
Douglas Tosi