Subject Re: [Firebird-Architect] Re: Batch statements
Author Ann W. Harrison
David Johnson wrote:
> Given that Firebird's wire protocol is a known bottleneck, anything that
> reduces that data transmitted (time spent) on the wire will improve
> performance. We can blame Borland for a crummy wire protocol, but we
> don't have to be tied to Borland's past mistakes.

In which case, the answer is to fix the wire protocol - or better, as
Jim pointed out, the actual problem which is that every byte moving
between client and server is copied at least eight times. Adding new
bulk statement that will further complicate error recovery on the client
side (ok, there was a uniqueness violation .... in which of the 37
records?) doesn't address the general problem of networking overhead.