Java Client queryDataSource w/Large Data Source causes Delays?
Java Client queryDataSource w/Large Data Source causes Delays?
- Subject: Java Client queryDataSource w/Large Data Source causes Delays?
- From: Mike Fuselier <email@hidden>
- Date: Mon, 30 Aug 2004 09:17:43 -0500
I have a big Java Client Desktop application. It's a marine logistics
program with a database that contains 250,000 shipping requests. I
have a simple Interface Controller that lets my users manipulate that
table. For the most part it works OK.
But, the users complain of delays in the program to the point that they
call me 2 to 3 times a day. We are running a G4 XServe, MySQL database
and G5 workstations. There currently is only 1 instance of the
application running because we've had problems with > 1 instance when
reports generated from different instances showed different data (yeah,
it was ugly).
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.
The application server has -Xms128m -Xmx512m as its application
argument giving it 128 megabytes of memory and allows expansion to 512
megabytes. I've played with this setting but really got nowhere.
Right now, the application has been running for nearly 3 days and
WOStats page shows 796,393,472 bytes total memory with 242,410,272
free. The free number fluctuates wildly during the course of any day.
I've seen as little as 20k free.
When the server slows down, the WOStats page stops responding. The
HTML direct action components won't load. Basically we just have to
wait until the application server starts responding.
Any help would be appreciated.
_______________________________________________
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.