Hi team,
I am trying to read max size xlsx files of around 112 MBs . I am able to read them properly but my server which stays at around 30-40% CPU usage normally shows frequent CPU spikes of 90-98% while reading the file . Means this file reading jar is itself hitting CPU of around 20-30 % utilisation.
My usage of jar is as below :
`
InputStream is = null;
Workbook workbook = null;
int minLineDataLength=columnCount;
try {
is = new FileInputStream(new File(filePath));
workbook = StreamingReader.builder()
.rowCacheSize(100)
.bufferSize(4096)
.password(password)
.open(is);`
Hi team,
I am trying to read max size xlsx files of around 112 MBs . I am able to read them properly but my server which stays at around 30-40% CPU usage normally shows frequent CPU spikes of 90-98% while reading the file . Means this file reading jar is itself hitting CPU of around 20-30 % utilisation.
My usage of jar is as below :
`