Ann W. Harrison wrote:

> Multiple values are of much less interest if you prepare your queries.
> The advantage of multiple values per insert is primarily that the
> database doesn't have to parse, compile, and optimize the query for
> each set of values. Prepared statements do that too. EXECUTE BLOCK
> doesn't.

There is also the problem of multiple round-trips to the server with
multiple INSERT statements. If Firebird is running on a different
physical machine (even out-of-proc would make a difference) then the
round-trip time could become significant.

Dean.