Hi, I have implemented 'SortedMapBackedCache' in my SqlEntityProcessor for the child entities in data-config.xml. And i'm using the same for full-import only. And in the beginning of my implementation, i had written delta-import query to index the modified changes. But my requirement grew and i have 17 child entities for a single parent entity now. When doing delta-import for huge data, the number of requests being made to datasource(database) became more and CPU utilization was 100% when concurrent users started modifying the data. For this instead of calling delta-import which imports based on last index time, I did full-import('SortedMapBackedCache' ) based on last index time.
Though the parent entity query would return only records that are modified, the child entity queries pull all the data from the database and the indexing happens 'in-memory' which is causing the JVM memory go out of memory. Is there a way to specify in the child query entity to pull the record related to parent entity in the full-import mode. Thanks and Regards, Srinivas Kashyap DISCLAIMER: E-mails and attachments from TradeStone Software, Inc. are confidential. If you are not the intended recipient, please notify the sender immediately by replying to the e-mail, and then delete it without making copies or using it in any way. No representation is made that this email or any attachments are free of viruses. Virus scanning is recommended and is the responsibility of the recipient.