Re: Ideas on creating connections

2003-09-26 Thread Director General: NEFACOMP
t;; <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 23:55 Subject: RE: Ideas on creating connections try adding a '\' before the comma like a \n in c++ -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 20

RE: Ideas on creating connections

2003-09-25 Thread Mike R. Duncan
try adding a '\' before the comma like a \n in c++ -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 10:41 AM To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Ideas on creating connections Tha

RE: Ideas on creating connections

2003-09-25 Thread Roger Davis
working on now, as it definately needs updating). Roger > -Original Message- > From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 25, 2003 1:41 PM > To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Ideas on creating connecti

RE: Ideas on creating connections

2003-09-25 Thread Miguel A. Gonzalez
$0.02 Regards, Miguel -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 12:48 PM To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Ideas on creating connections I never use DAO. Is there any benefit ove

Re: Ideas on creating connections

2003-09-25 Thread Director General: NEFACOMP
time I saw such a code on http://www.vbmysql.com but it seems to have dissappeared. Thanks Emery - Original Message - From: "Roger Davis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 19:08 Subject: RE: Ideas

RE: Ideas on creating connections

2003-09-25 Thread Roger Davis
> -Original Message- > From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 25, 2003 12:48 PM > To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Ideas on creating connections > > > I never use DAO. > >

Re: Ideas on creating connections

2003-09-25 Thread Jeremy Zawodny
On Thu, Sep 25, 2003 at 06:47:10PM +0200, Director General: NEFACOMP wrote: > > What is connection pooling? http://search.yahoo.com/search?ei=UTF-8&fr=sfp&p=what+is+connection+pooling > How big should my memory be if 200 connections may be required? What memory? That depends on your platform.

Re: Ideas on creating connections

2003-09-25 Thread Director General: NEFACOMP
I never use DAO. Is there any benefit over ADO? Thanks Emery - Original Message - From: "Roger Davis" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, Se

Re: Ideas on creating connections

2003-09-25 Thread Director General: NEFACOMP
1? Thanks Emery - Original Message - From: "Dan Greene" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 18:17 Subject: RE: Ideas on creatin

RE: Ideas on creating connections

2003-09-25 Thread Dan Greene
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 lifespan... if your clients are fi

RE: Ideas on creating connections

2003-09-25 Thread Roger Davis
My experience is this. I use DAO through MyODBC, and I also use the libmysql.dll with a custom recordset. Connection times through both options are extremely fast. Fast enough in my situation that it can basically can be ignored. There are times when I open several connections to the server at o