Re: Deleting objects causes OutOfMemory...
Re: Deleting objects causes OutOfMemory...
- Subject: Re: Deleting objects causes OutOfMemory...
- From: Kieran Kelleher <email@hidden>
- Date: Thu, 17 May 2007 07:51:40 -0400
Are any of those entities using inheritance. and if so, what kind?
On May 17, 2007, at 7:37 AM, Shravan Kumar.M wrote: Hi Kieran/Group,
1) Actually the SELECT query generated by EOF when I instruct it to delete objects is seems to be wrong.
2) There are just 100 D records which am trying to delete. But due to a wrong SELECT query fired by EOF, 1000's of records are fetched in to memory and resulting OutOfMemory. Donno how this wrong query is generated by EOF. I think if we can fix this query issue, we'll get some solution.
Main issue with query is, the wrong join it made in the below query. If you can tell me how EOF decides on which join to make while constructing SELECT query during deleting objects. I will try to debug in those lines.
SELECT dCol1,dCol2 FROM D WHERE d_c = 12345 .
Structure of D table: ~~~~~~~~~~~~~~~~~~
d_id pk d_a fk to A table d_b fk to B table d_c fk to C table
Am running this app on a dev machine... with default java Xms and Xmx args Thanks & Rgds, Shravan Kumar.M
"Let us learn from the past to profit by the present,and from the present to live better in the future." --William WordsWorth ---------------------------------------------------------------
On 17-May-07, at 4:32 PM, Kieran Kelleher wrote: 1) About how many D items at the end of the relationship?
2) What is your memory settings for the app (Xms and Xmx args)
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden