I assume that you are running the app locally through Apache as that message is from wotaskd. As OC pointed out, the Receive Timeout is what you need to adjust up and up and up.
It sounds like latency is what is killing you, I don’t recall how chatty JDBC is but it is probably along the lines of ODBC which is quite chatty indeed. Latency kills its performance. Another possibility is to run a local copy of the DB. Chuck On 2016-04-05, 7:38 AM, "webobjects-dev-bounces+chill=gevityinc....@lists.apple.com on behalf of OC" <webobjects-dev-bounces+chill=gevityinc....@lists.apple.com on behalf of o...@ocs.cz> wrote: >Benjamin, > >On 5. 4. 2016, at 11:02, Benjamin Chew <bc...@smarthealth.com> wrote: > >> 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). > >As others have pointed out, ping times could hardly affect this. > >> 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. > >Far as I can say with my very limited knowledge, > >(a) “No Instance Available” is most time (if not always) caused by the receive >timeout at the server side; >(b) and thus, increasing it enough should help. > >> Does anyone have any ideas? > >First thing, I would try some ludicrously high receive timeout. For us, it >always helped (in the sense that the rendered page did always return, presumed >the user had the patience to wait long enough, especially when by a mistake I >had computed some results in O(2^N) :)) > >It might also help to check the adaptor log -- touch /tmp/logWebObjects as >root, and the log should appear in /tmp/WebObjectsLog. > >The ultimate solution, of course, would be background processing and/or >paging, as others already recommended; but first you need to find the >particular cause of the long processing, which might be sometimes a bit hairy. > >All the best and good luck, >OC > > > _______________________________________________ >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/chill%40gevityinc.com > >This email sent to ch...@gevityinc.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
