Correct, prepared statements are the way to go.
However, other databases have the option of sending multiple sets of
parameters in one go. That's the only thing (except for updateable
joins) that I miss.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Aage Johansen
Sent: Friday, May 20, 2005 3:42 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: bulk insert

Rick Debay wrote:

> Unfortunately, you still need to send the values one at a time and

get > back each response.

> Sending a bunch of parameters at once and getting back one response
> isn't supported.

I'm not sure I understand your points, but if I do:
Even though parameters and responses go back and forth, you will save
some time by avoiding parsing & optimizing the query.

--
Aage J.