RE: Connection Pooling - Chris Herridge - com.mysql.lists.dotnet

17 messages in com.mysql.lists.dotnetRE: Connection Pooling

From	Sent On	Attachments
Bill Angus	21 Dec 2005 09:56
Jorge Bastos	21 Dec 2005 10:13
Darren Hill	21 Dec 2005 13:40
Darren Hill	21 Dec 2005 13:46
Darren Hill	21 Dec 2005 14:09
Philip Denno	21 Dec 2005 14:13
Chris Herridge	21 Dec 2005 14:16
Darren Hill	21 Dec 2005 14:54
Darren Hill	21 Dec 2005 15:28
Chris Herridge	21 Dec 2005 15:34
Philip Denno	21 Dec 2005 15:37
Darren Hill	21 Dec 2005 15:39
Bill Angus	21 Dec 2005 19:09
Kevin Turner	22 Dec 2005 01:10
Daniel Fisla	22 Dec 2005 08:18
mdan...@psychtest.com	22 Dec 2005 09:43
David Dindorp	27 Dec 2005 03:22

Subject:	RE: Connection Pooling
From:	Chris Herridge (chr...@herridge.co.uk)
Date:	12/21/2005 02:16:34 PM
List:	com.mysql.lists.dotnet

I know this sounds silly but are you calling conn.Close(); in the Page_Unload or Page_Error event handlers?

-----Original Message----- From: Darren Hill [mailto:dhi...@ormac.com] Sent: 21 December 2005 22:10 To: dot...@lists.mysql.com Subject: RE: Connection Pooling

Further still,

I'm trying ... Pooling=true; max pool size=30; min pool size=5; ... after a few clicks, I run it to the classic "error connecting: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached."

It appears that the connector is NOT reusing connections, is that not the purpose of pooling? And keeping connections open, etc?

________________________________________ Darren Hill - dhi...@ormac.com

Ormac Digital Content Management and IT Solutions www.ormacdigital.com (416) 410-1154

Ormac Management Inc. Management Consulting Services www.ormac.com (416) 533-9756

________________________________________

-----Original Message----- From: Darren Hill [mailto:dhi...@ormac.com] Sent: December 21, 2005 4:47 PM To: dot...@lists.mysql.com Subject: RE: Connection Pooling

Further,

Since I need to kill the aspnet_wp.exe (or w3wp.exe on the server) in order to release the connections, could it be an issue in the .Net framework?

________________________________________ Darren Hill - dhi...@ormac.com

Ormac Digital Content Management and IT Solutions www.ormacdigital.com (416) 410-1154

Ormac Management Inc. Management Consulting Services www.ormac.com (416) 533-9756

________________________________________

-----Original Message----- From: Darren Hill [mailto:dhi...@ormac.com] Sent: December 21, 2005 4:41 PM To: dot...@lists.mysql.com Subject: Connection Pooling

Ok,

I consider myself fairly educated and savvy when it comes to development, yada yada. I CANNOT get my head around Connection Pooling. I get the idea behind it, and love the idea AND want to take advantage of it, but as soon as I say Pooling=true;, I run into HUGE problems. Specifically running out of connections.

I've done a bunch of reading on the subject and played around with timeouts and such ... can some PLEASE start me down the right path. One scenario is I've got a simple web site, makes one select db call per page (for contents), and it's a fairly active site ... say 3000 hits per day. Can someone tell me what the parameters in the connection string should be in order to maximize performance? Even start me down the right path?

HELP!

________________________________________ Darren Hill - dhi...@ormac.com

Ormac Digital Content Management and IT Solutions www.ormacdigital.com (416) 410-1154

Ormac Management Inc. Management Consulting Services www.ormac.com (416) 533-9756

________________________________________