Subject Re: [firebird-support] Insert multiple rows with one Execute ?
Author David Johnson
On Wed, 2005-08-24 at 18:11 +0000, kapsee wrote:
> Is there a way you can insert multiple rows with a single execute
> call ? I know you can use the same prepared statement, set different
> bind values and execute everytime but this is going to take N
> roundtrips to the server to insert N rows. Is there a better way ?
> Thanks!
Not yet, but a lot of Java folks are pushing for this feature that is
common in other databases (and improves bulk data load performance by
huge margins).