freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Connection support only one query at a time

From: "Gunther Van Butsele" <gvb AT velleman.be>
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Connection support only one query at a time
Date: Fri, 22 May 2009 16:18:08 +0200

>
> 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.
>

I find it doubtfull that you are executing thousands of queries
concurrently with a perl script..

If you execute queries sequentially you don't need to close/reopen the
connection every time. Maybe you misinterpreted the "at a time"
incorrectly?

Regards

Gunther

[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