List:General Discussion« Previous MessageNext Message »
From:Dan Greene Date:September 25 2003 4:17pm
Subject:RE: Ideas on creating connections
View as plain text  
The general rule of thumb is that connection creation/destruction is the most costly part
of approach #2.  However, it is unlikely that each connection needs a dedicated
connection, and therefore memory resources on the server for the entirity of the client's

if your clients are firing off many queries back-to-back, buy a lot of memory for your
server, and go w/ your option #1.

if it's a typical app, where the user queries data, looks through it for a bit, then
queries more, yadda, yadda, yadda, then what you're probably going to want to do is #2.  

Without a central 'app server' as such, you can't really take advantage of connection
pooling.  The closest you can do is write into your app that if the connection is idle for
x amount of time, then it closes the connection, and reestablishes it upon next data

Hope this helps...

Dan Greene

> -----Original Message-----
> From: Director General: NEFACOMP [mailto:dg@stripped]
> Sent: Thursday, September 25, 2003 11:57 AM
> To: myodbc@stripped; mysql@stripped
> Subject: Ideas on creating connections
> Hi groups,
> I need some experienced users to guide me on this issue.
> I am developping an Application that will be accessing a 
> MySQL database through MyODBC.
> The application is developped using Visual Basic.
> Since my application will be used simultaneously by more than 
> 200 users, I want to know the implication of using one of the 
> following methods for connecting to the server:
> 1. At logon, I create a connection to the server and maintain 
> it throught the application life. By the application life I 
> mean that the connection stays open as long as the 
> application is loaded in the memory. So, for a user who is 
> online for 3 hours, the connection is on for those three 
> hours, even if the user goes out for a coffee.
> 2. I create a connection only when a query is about to be 
> sent to the server. That means, I create a connection when I 
> want to create an ADO recordset and run a query against the 
> server. After running my query, I distroy the connection. 
> Currently I am using the first option since I don't exactly 
> what it is required (time and resources) to make a connection 
> to the server. Will you please tell me how fast is to connect 
> to the server. If you advise me that this method is the best, 
> I will add functions to reconnect a dead connection.
> Any ideas and advices are highly welcomed
> Thanks,
> __________________________________
> NZEYIMANA Emery Fabrice
> NEFA Computing Services, Inc.
> P.O. Box 5078 Kigali
> Office Phone: +250-51 11 06
> Office Fax: +250-50 15 19
> Mobile: +250-08517768
> Email: dg@stripped
RE: Ideas on creating connectionsDan Greene25 Sep
RE: Ideas on creating connectionsMike R. Duncan26 Sep