New SQL Statement without re-opening connection - SQL Recipes a FREE cookbook of SQL queries and examples

coyotemrh · #1 (**permalink**) 07-02-2008, 05:27 PM

I have an sql routine that is pretty slow. I think the problem is that everytime I run the update, the open is re-establishing the server connection.
Anyway to keep the server connection open? Kind of like a requery command, but requery only refreshes the data as I understand it ...

ben · #2 (**permalink**) 07-03-2008, 07:04 AM

What RDBMS are you using?
Do a search for "Persistent" connection in your manual.

#3 (**permalink**) 08-26-2008, 09:18 AM

Quote:

Originally Posted by coyotemrh

I have an sql routine that is pretty slow. I think the problem is that everytime I run the update, the open is re-establishing the server connection.
Anyway to keep the server connection open? Kind of like a requery command, but requery only refreshes the data as I understand it ...

Have you used "Begin Tran" and "Commit Tran" in your SQL routine???

Thanks
Sandesh S
Microsoft SQL Server

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

User Name		Remember Me?
Password