Re: Connection support only one query at a time

"Gunther Van Butsele" <[email protected]> Fri, 22 May 2009 16:18:08 +0200

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<[email protected]>

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