Pepek,

> > The normal cause of wild variations in the performance of queries is
> garbage
> > collection...
>
> Garbage collection doesn't seem to play any significant part. I even
> deleted the whole backup table, performed the backup/restore cycle, and
> still got long times. What *did* help was limiting the SELECT from
> sourcetable to "significant records", some 6000 of them (a reduction of
> two orders of magnitude). But it still seems strange that Firebird would
> choke on INSERTs, even in what I perceive to be the ideal condictions to
> the server.
>

OK, then we'll need to look for less common problems. When the query is
slow,
are you seeing lots of page faults? Process size growth? What is the rate
of
reads/writes/marks/fetches? Do you have any guess as to where the time
is going?


Good luck,

Ann


[Non-text portions of this message have been removed]