1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

New SQL Statement without re-opening connection

Discussion in 'General DB Chat' started by coyotemrh, Jul 2, 2008.

  1. coyotemrh New Member

    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 ...
    coyotemrh, Jul 2, 2008
    #1

  2. ben Administrator

    What RDBMS are you using?
    Do a search for "Persistent" connection in your manual.
    ben, Jul 3, 2008
    #2

  3. Unregistered Guest


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

    Thanks
    Sandesh S
    Microsoft SQL Server
    Unregistered, Aug 26, 2008
    #3

Share This Page