Subject Re: [firebird-support] Re: Simultaneous inserts / selects
Author Mark Rotteveel
On 9-10-2014 14:57, 'E. D. Epperson Jr' dixonepperson@...
[firebird-support] wrote:
> I'm joining this late and may have some of the details incorrect. But
> doesn't your client tool have a batch insert object? If your client is
> written in either Delphi or .NET, I'm pretty sure it does and that would
> be the best way to insert bulk records.

Firebird doesn't actually support batching, so it is usually supported
on a driver level by repeatedly executing the prepared statement with
multiple parameter sets just like you would do yourself.

There is currently no real performance benefit from using batching
functionality over re-using a prepared statement yourself.

In theory drivers with their own wire protocol implementation might be
able to achieve some increase in performance by sending multiple execute
requests before waiting on the responses, but as far as I know currently
no driver does this.

Mark Rotteveel