Subject Re: [firebird-support] very slow commit
Author Milan TomeŇ° - Position
Dne 09.02.2010 13:26, svanderclock napsal(a):
> hello,
>
> I update one row in 10 tables with a lot of index. (around 300 index
> to update)
>
> to insert or Update the data it is very fast (around 100ms)
>
> but, when i commit the SQL, it is very slow (around 3 to 6 seconds!).
> i see also that my hardrive is use a lot in the commit.
>
> how to speed up the commit ? is it a normal behavior ?
>
> thank you by advance
> stephane

AFAIK Indexes are updated during commit.
You can do these steps:
1. Before a bulk load of a lot of records it's recommended to deactivate
indexes and activate them after loading is done
2. Reduce index count

Milan