Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_vb thread: Re: Quick Performance Question


Message #1 by "Niall Hannon (ext. 772)" <Niall.Hannon@f...> on Tue, 9 Apr 2002 09:58:45 +0100
Hi,

Just a quick question. I have a VB app which reads and writes from MSSQL. To
this I use a lot of recordsets. Are there any performance issues with
opening these recordests but not closing them? For example, if I opened 20
but didnt close them when they were no longer required would this slow down
the performance of the app?

Thanks
Niall

Niall Hannon
Management Information Systems
 ___________________________________________

FINEOS

Pembroke House
8 - 10 Lower Pembroke St
Dublin 2

Ph: +xxx x xxxxxxx
Fax: +xxx x xxxxxxx

Why don't you visit our website at http://www.FINEOS.com

ENTERPRISE SOLUTIONS FOR BANKING AND INSURANCE
___________________________________________



**************************************************************************
The information contained in this e-mail is confidential,
may be privileged and is intended only for the use of the
recipient named above. If you are not the intended
recipient or a representative of the intended recipient,
you have received this e-mail in error and must not copy,
use or disclose the contents of this email to anybody
else. If you have received this e-mail in error, please
notify the sender immediately by return e-mail and
permanently delete the copy you received. This email has
been swept for computer viruses. However, you should
carry out your own virus checks.


Registered in Ireland, No. 205721. http://www.FINEOS.com
**************************************************************************


  Return to Index