freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] Connection support only one query at a time

From: Matthias Cramer <matthias.cramer AT interway.ch>
To: freetds AT lists.ibiblio.org
Subject: [freetds] Connection support only one query at a time
Date: Fri, 22 May 2009 11:05:02 +0200

Hi

I have a problem, which is described in the FAQ under "Why does each
connection support only one query at a time?".
Is there some workaround to this. I think in my case this is a very big
performance killer.

I use DBI:Sybase in perl to connect to a MS SQL Server 2008. I do several
thousand queries in my script and for each it needs to
open a new connection.

Is there a solution to that?

Regards

Matthias

--
Matthias Cramer / mc322-ripe System & Network Manager
Interway Communication GmbH Phone +41 43 500 1111
Josefstrasse 225 Fax +41 44 271 3535
CH-8005 Zürich http://www.interway.ch/
GnuPG 1024D/2D208250 = DBC6 65B6 7083 1029 781E 3959 B62F DF1C 2D20 8250

[freetds] Connection support only one query at a time, Matthias Cramer, 05/22/2009
- Re: [freetds] Connection support only one query at a time, James K. Lowden, 05/22/2009
  - Re: [freetds] Connection support only one query at a time, Matthias Cramer, 05/22/2009
    - Re: [freetds] Connection support only one query at a time, Frediano Ziglio, 05/22/2009
- Re: [freetds] Connection support only one query at a time, Gunther Van Butsele, 05/22/2009