Yes, that is correct. So it is good not have not 3 second queries :-) and if you do have them and can identify them in advance, run them in a separate EOF stack to avoid impacting the other users.
Chuck From: <[email protected]> on behalf of Leigh Kivenko <[email protected]> Date: Monday, June 6, 2016 at 9:47 AM To: Ramsey Gurley <[email protected]> Cc: "[email protected]" <[email protected]> Subject: RE: Question about jdbc connection pool Thanks Ramsey. Does that mean there is only 1 database connection shared by all end-users of an app? So if a user hits a query that runs for 3+ seconds all other application users are stuck waiting for that query to complete? Leigh Kivenko | VP, Technology PortfolioAid t. 416-479-0523 | e. [email protected]<mailto:[email protected]> This e-mail may be privileged and confidential. If you received this e-mail in error, please do not use, copy or distribute it, but advise me immediately (by return e-mail or otherwise), and delete the e-mail. From: [email protected] [mailto:[email protected]] On Behalf Of Ramsey Gurley Sent: Monday, June 06, 2016 12:18 PM To: Leigh Kivenko <[email protected]> Cc: [email protected] Subject: Re: Question about jdbc connection pool The ObjectStoreCoordinator opens one connection which everything shares by default. If you want multiple connections, you have to create multiple OSCs. There’s an OSC pool built into Wonder, but it leaks memory. On Jun 6, 2016, at 8:40 AM, Leigh Kivenko <[email protected]<mailto:[email protected]>> wrote: Hello, How does one set the jdbc connection pool size? Is there a default if this isn’t specifically set? Thanks, Leigh Kivenko | VP, Technology PortfolioAid t. 416-479-0523 | e. [email protected]<mailto:[email protected]> This e-mail may be privileged and confidential. If you received this e-mail in error, please do not use, copy or distribute it, but advise me immediately (by return e-mail or otherwise), and delete the e-mail. _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]<mailto:[email protected]>) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth.com This email sent to [email protected]<mailto:[email protected]>
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
