To use SXSSFWorkbook in POI is a stream-based writing method based on XSSF, which allows only part of the data to be retained in memory, significantly reducing memory usage and increasing reading speed.
Reduce the amount of data: If the Workbook contains a large amount of data, consider reducing the data by only reading the necessary parts or reading the data in batches.
Using cache: You can improve reading speed by storing data in memory and reducing the number of times it is read from the hard drive.
Consider using multiple threads to simultaneously read data in order to improve reading speed.
Utilize indexes: If you need to frequently search for data, you can use indexes to improve search speed.
Optimize code by checking for inefficient areas, improving code logic, and reducing unnecessary computations and operations.