Hi Ben,

Your ping time isn’t the issue for sure, as far as I remember the time out is 
something like a minute…
I think the issue is more on the “application” side.
Try to see if you have anyway to get some log. Eventually output the SQL for 
your app to see if you forget to do some batch when accessing the database (if 
you see a row by row select, that is probably the primary issue to fix)
If it’s a Wonder app: 
log4j.logger.er.transaction.adaptor.EOAdaptorDebugEnabled=INFO either on your 
Property file or as a launch argument.

Xavier


> On 05 Apr 2016, at 11:02, Benjamin Chew <bc...@smarthealth.com> wrote:
> 
> Hi Everyone,
> 
> I’m wondering if any of you kind souls can help me. :)
> 
> I’m in Singapore working off a VPN connection to the States, and while 
> waiting for some database-intensive components to display, I keep getting “No 
> Instance Available” because it’s taking so long to complete all the queries 
> (ping times ~ 200ms). 
> 
> I’ve tried going to WOMonitor on my local machine (localhost:56789) and 
> modified the Send, Receive and Connect timeouts, but that didn’t seem to 
> help. I’ve also tried changing WOMaxSocketIdleTime and WOLifebeatInterval in 
> my Eclipse debugging profile, but that didn’t help either.
> 
> Does anyone have any ideas?
> 
> Thanks,
> Ben
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/webobjects%40anazys.com
> 
> This email sent to webobje...@anazys.com


 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Reply via email to