| Subject | Re: [firebird-support] Blob Parsing Stored Procedure |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2007-07-03T14:22:51Z |
Hi Luke!
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.
Set
[Non-text portions of this message have been removed]
> I've got a lot of small inserts to do and its just taking much longerWhat is 'a lot of small inserts'? Are we talking millions? How are you inserting and how many records per second do you achieve?
> 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.
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.
Set
[Non-text portions of this message have been removed]