more information

Results 1 to 2 of 2

Thread: more information

  1. #1
    Join Date
    Dec 1969

    Default more information

    In my code I have pages that require mulitple calls. So if I have four SQL calls, I have 4 open and closes and 4 recordsets. I close each recordset and connecton right after the looping through of the recordsets. In some cases I might have mulitple connections open at once, but I close them down as soon as possible. Am I missing the obvious? <BR><BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: more information

    NEVER NEVER NEVER use multiple connections unless you are truly accessing different DATABASES, not just tables in the same database! (And if you *are* doing that, then think *real* hard as to why you need to! Is there *really* any reason you can&#039t use multiple tables in the same DB?)<BR><BR>Connections are *VERY* expensive to set up and tear down, in terms of system resources. You are far, far, far better off to open one connection and use it to work with as many recordsets as needed. You certainly do *NOT* need more than one connection per database, ever.<BR><BR>Hokay?<BR><BR>As for the recordsets: Sure, closing them as soon as you are done with them is a good idea. Even doing<BR> &nbsp; Set RS = Nothing<BR>isn&#039t a bad idea, though it might not help as much as some authors try to get you to believe.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts