Persistent conection? 
Author Message
 Persistent conection?

I want to know which choise is better:

a) Open 1 (one) connection using ADO and ODBC at the
beginnig of the program, and then close it at the end
(persistant conection).

b) Open a connection at the beginnig of all the procedures
or functions that requires a connection (ADO and ODBC) and
then close it at the end of the procedures or functions
(requiered conection).

Consider that:
1) 80% of the time I need to access the DB.
2) Openning a connection is a slow procedure.
3) Leaving a connection open, means innecesary trafic in
the network.

Which is the best choise, a) or b) ???????

* Sent from AltaVista http://www.*-*-*.com/ Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping.  Smart is Beautiful

Mon, 09 Sep 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Help with ODBC Conection Code

2. Conection to IMAP with CDO

3. Checking for Oracle Conection

4. Database (MSSQL 6.5) conection over OLE ?

5. Internet Conection from VB5

6. Internet conection from VB5

7. ADO-VB6-Excel Conection

8. Disconnect an Dial Up Networking conection

9. E-mail & Modem Internet Conection Detection

10. Conection Speed

11. RAS Conection Over IP

12. conection speed


Powered by phpBB® Forum Software