Hi, I am using CachedsqlEntityProcessor in my DIH dataconfig to reduce the number of queries executed against the database ,
<Entity1 query="select * from x" processor= "CachedsqlEntityProcessor"/> <Entity2 query="select * from y" processor= "CachedsqlEntityProcessor" cachekey="id" cachelookup="x.id"/> I having more than 2 million rows returned for Entity 2 and around 300000 rows returned for entity1. I am have set the heap size to 1 GB but even then I am always getting heap out of size error. I am not sure how to flush the documents in buffer at certain condition. I tried to enable Autocommit / reduced the maxdocbuffersize but of no use.. Can someone let me know what is the best way to overcome this issue? Thanks, Barani -- View this message in context: http://old.nabble.com/DIH---Out-of-Memory-error-when-using-CachedsqlEntityProcessor-tp27889623p27889623.html Sent from the Solr - User mailing list archive at Nabble.com.