thomas_besand wrote:

> ...
> Well anyway, I implemented the COMMITs on every 10000 writes, as Dan
> and others proposed, so now Firebird grabs itself around 16k of memory
> and stays stable at that. If I take a look at the logfile, I can see
> it's taking roughly 2 min/10000 records steadily. So this side begins
> to look good.

16KB? Or 16MB? Maybe you should tune the PageSize and NoOfBuffers - try
PageSize=8KB and Buffers=8.000-10.000.

> I thought at first that if AutoCommit was turned on for the
> ZeosConnection, I wouldn't need to bother about committing explicitly.
> This seems obviously not true.

Did you investigate other component sets (IBO, FIB)?
Depending on a lot of things(!), an insert speed of several 1000/sec is
possible.


--
Aage J.