FreeTDS Development Group

["Jorge Cordero" <jorge.cordero AT gmx.net>]

A encouragement thought, for all those boldly openly writing and
documenting :)

"Documentation is like sex. When it is good, it is very very good.
When it is bad, it is better than nothing."
- Bruce Perence

Jorge C

-----Mensaje original-----
De: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org]En nombre de Lowden, James K
Enviado el: Friday, June 24, 2005 12:23 PM
Para: FreeTDS Development Group
Asunto: RE: [freetds] DBlib dbsqlexec question (chaining sql
statements)


> From: Patrick Dunnigan
> Sent: Friday, June 24, 2005 9:22 AM
>
> one more question, is there any performance gain from dbsqlexec
> once for say 10 sql statements compared to 10 times for those same
> sql statements?

As Frediano said, there is some slight performance gain in reducing
network traffic.  Any efficiency gains, though, are usually
overwhelmed
by two things:

1.  Query execution time
2.  Program complexity

I would suggest you reduce #2 to the extent possible.  If it's more
convenient to call  dbsqlexec() once with several statements, do so,
else don't.  :-)  Just remember to exhaust the results with a loop
until
dbresults() returns NO_MORE_RESULTS.

--jkl


-----------------------------------------
The information contained in this transmission may contain privileged
and
confidential information and is intended only for the use of the
person(s) named
above. If you are not the intended recipient, or an employee or agent
responsible
for delivering this message to the intended recipient, any review,
dissemination,
distribution or duplication of this communication is strictly
prohibited. If you are
not the intended recipient, please contact the sender immediately by
reply e-mail
and destroy all copies of the original message. Please note that we do
not accept
account orders and/or instructions by e-mail, and therefore will not
be responsible
for carrying out such orders and/or instructions.  If you, as the
intended recipient
of this message, the purpose of which is to inform and update our
clients, prospects
and consultants of developments relating to our services and products,
would not
like to receive further e-mail correspondence from the sender, please
"reply" to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the
Americas, New York,
NY 10105.
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds