It sounds like, in effect, that you are basically making a copy of your database table with ~350k records in memory!
What happens when 2 users hit your website at the same time? What happens when 100 users hit your site?
I don't know the specifics of what you are doing, but it doesn't sound like a particularily good solution. Why do you think you need to have the entire result set in memory?
phil.
[ Muliawan Sjarif ] wrote:
If I need the entire resultset in the memory what would be the best approach? It seems that broker.getCollectionByQuery(q) stuck with huge records.
On Tue, 12 Oct 2004 16:09:11 -0400, WHIRLYCOTT <[EMAIL PROTECTED]> wrote:
You probably are doing something like this:
Collection c = broker.getCollectionByQuery(q);
... and ought to be doing something like this:
Iterator i = broker.getIteratorByQuery(q);
Unless you need the entire result set in memory, this should be your preferred approach. Just iterate through the results and do what you need to do to each of them.
phil.
[ Muliawan Sjarif ] wrote:
Hi,
I was doing a quick test for OJB particularly using PersistenceBroker on one table that consists of 352544 records. No matter how many times I tried, in the end all I got was the browser not responding (no result displayed on the page) and tomcat throwed java.lang.OutOfMemory exception. For this test, dynamic proxy was utilized.
Pertaining to this problem, I wonder if anyone has encountered similar problem. Or is there somewhere in the OJB's properties that need to be tweaked?
Many thanks.
Regards, Muliawan
-- Whirlycott Philip Jacob [EMAIL PROTECTED] http://www.whirlycott.com/phil/
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- Whirlycott Philip Jacob [EMAIL PROTECTED] http://www.whirlycott.com/phil/
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
