Memory heap error

[Anonymous]

I was getting memory heap error whenever i pull excel from input. I have resolved it somehow by changing the setting given in the attached JPG file. Now the performance is very slow. Please suggest the setting which i should have for a better performance.  Is it everywhere the xmx and xmx should be in sync?

[Anonymous · Accepted solution]

On top of that, the execution time is taking more than 45min to complete a simple job which has only InputExcel-->tLogRow

My machine is having 8GB RAM, i think this is enough but still the execution time is longer.

[manodwhb]

@samisyed80,yes ,you try with sync,even you might preocessing large file. memory you need to use based on size of files.

[David_Beaty]

There are many utils/java routines that allow you to extract all columns/rows from a sheet in an Excel spreadsheet into a CSV

You'll probably be better off doing this and then consuming the resulting CSV - especially if the Excel sheet is very large.