Subject Re: [firebird-support] Blob Parsing Stored Procedure
Author Svein Erling Tysvær
Hi Luke!

> I've got a lot of small inserts to do and its just taking much longer
> than I'm willing to wait for (even with an embedded DB). Basically
> these inserts are small records (roughly 4 BIGINT's) that have a FK to
> another larger table.

What is 'a lot of small inserts'? Are we talking millions? How are you inserting and how many records per second do you achieve?

Generally, Firebird is good at executing stuff once things are prepared in a transaction. A few thousand inserts per second is often feasible. Preparing for each repetition will slow down things considerably, and starting a new transaction or connection for each repetition will make things unbearably slow.


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