Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

High CPU utilisation spikes recorded #262

Open
jayantjain001 opened this issue Nov 26, 2022 · 3 comments
Open

High CPU utilisation spikes recorded #262

jayantjain001 opened this issue Nov 26, 2022 · 3 comments

Comments

@jayantjain001
Copy link

jayantjain001 commented Nov 26, 2022

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);`
@jayantjain001
Copy link
Author

jayantjain001 commented Nov 26, 2022

@monitorjbl
Please provide help for the same , or a change in config can help . I can keep at max 5,000 rows in memory as it is a multi threaded code... Please suggest what changes in config are required to keep cpu util low

@jayantjain001
Copy link
Author

@pjfanning can you help here ?

@jayantjain001
Copy link
Author

Just updated please help @pjfanning @monitorjbl

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant