My understanding is that a "No instance available" comes from your Apache's WOAdaptor. Therefore it shouldn't basically have nothing to do with your VPN or slow internet connection.
Daniele has already suggested using a ERXLongResponsePage. Sometimes the problem is not a single database operation, but a WORepetition iterating over a huge array of objects and then - inside the WORepetition - calling another db/eof-intensive method on each item, like e.g. 'item.littleDatabaseWork()'. While each 'item.littleDatabaseWork()' may only take some ms, iterating over a lot of items may be too much. In this case, 'pagination' of large arrays may be the best solution. Use a ERXDisplayGroup in this case. C.U.CW -- The three great virtues of a programmer are Laziness, Impatience and Hubris. (Randal Schwartz) > On 05.04.2016, at 11:23, Daniele Corti <ilde...@gmail.com> wrote: > > Hi Benjamin, > if I understand correctly the problem is a intensive work on the DB, that, > added to the slow connection, make WOMonitor return the "No Instance > Available" error. > > if used in local network, these pages use more than 3/4 seconds to load? I'm > asking this, because I think it's a good practice in these scenarios to > introduce an intermediate page with a > ERXLongResponseTask.DefaultImplementation subclass and a ERXLongResponsePage > component to let the user see a loading page while fetching from the DB > (example Search Result in large DB), before render the component. > > Is it possible to you to alterate the WO App to do this? > > Another solution can be to optimize the DB (maybe moving on a dedicate > machine, physical or virtual, configured to speedup db results), making the > fetch result in few seconds. > > Bye > > Il giorno mar 5 apr 2016 alle ore 11:03 Benjamin Chew <bc...@smarthealth.com> > ha scritto: > 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/ildenae%40gmail.com > > This email sent to ilde...@gmail.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/cw%40i4innovation.de > > This email sent to c...@i4innovation.de
signature.asc
Description: Message signed with OpenPGP using GPGMail
_______________________________________________ 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
