Roman is correct. I'm talking about sending one statement with many
XSQLDA. The server would then loop through all the parameters,
executing the statement many times, and then return the results in one
set.
This cuts down on network overhead significantly, batches of statements
that took hours in SQL Server went to just under one hour.

-----Original Message-----
From: Firebird-Architect@yahoogroups.com
[mailto:Firebird-Architect@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: Friday, June 10, 2005 5:41 PM
To: Firebird-Architect@yahoogroups.com
Subject: Re: [Firebird-Architect] Batch statements

Rick Delay wrote:

> Is it possible to add an API to allow batched statements? I submitted

> a feature request and would like to know if there is a chance for it
> to be in 2.1 or at least 3.0.

Do you mean something like EXECUTE BLOCK in V2?

Regards,


Ann




Yahoo! Groups Links