Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
@samisyed80,yes ,you try with sync,even you might preocessing large file. memory you need to use based on size of files.
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.