Re: Java Client queryDataSource w/Large Data Source causes Delays?
Re: Java Client queryDataSource w/Large Data Source causes Delays?
- Subject: Re: Java Client queryDataSource w/Large Data Source causes Delays?
- From: Ray Ackland <email@hidden>
- Date: Tue, 31 Aug 2004 15:13:44 +1200
Mike,
Don't know the answer to this, but hope to provide some information to
help.
I experienced something similar - open a master record with 2500
related records and it takes a few seconds. Close that window and open
the master record again and it takes quite a while (timing it as I type
this).
Although I haven't done this for a while, when I used the option to
show the generated sql etc, I found that opening a record that had
already been opened (and closed) seemed to query quite a few of the
"extended" relationships.
In other words, while the first time opening the master record
retrieved all the related records and their details, the second time
fetched information for the related records relationships as well -
extending the time greatly.
This fell into the "too-hard-basket" for me at that time, so I haven't
gone back to investigate more fully.
Perhaps someone can suggest the reasoning for this behaviour?
r
PS couldn't tell you how long this second fetch took, as I'm at 10
minutes and still waiting.
On 31/08/2004, at 2:17, Mike Fuselier wrote:
If you load the interface window, query something that you know will
respond with tons of records, the responses show up in a short period
of time. So far, no problem. Close the interface window then open a
new one. If your last query (before closing last time) yielded lots
of records the window takes as long as 20 minutes to load. In the
mean time your application becomes unresponsive and other people
really slow down. That's generally when the users call me and request
we restart the server. If we restart, the problem goes away for a
while but eventually returns.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.