aie, and nothing can be change in the firebird.conf (memory optimization or write cache, or other) to speedup the process ?

we have bi processor with 32 GO of memory

thanks again
stephane

--- In firebird-support@yahoogroups.com, Milan Tomeš - Position <tomes@...> wrote:
>
>
> 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
>