Menu
I am using POI in my J2EE web application to generate a workbook. However, i find that POI takes around 3 mins to create a workbook with 25K rows(with around 15 columns each). Is this a POI performance issue , or is it justified to take that much of time? Are there other APIs known for better performance ?
214
The Poi was used, many years ago, by the indigenous Māori people of New Zealand to increase their flexibility and strength in their hands and arms as well as improving coordination. Wāhine (female) dancers perform the Māori Poi, a dance performed with balls attached to flax strings, swung rhythmically.
Poi is one of the flow arts' simplest and most common forms, where you swing two small weights around on cords. The physical activity feels great and the challenge of the movement engages you so fully that everything else melts away.
Fire poi has three types of grip: ball, single loop and double loop. The single loop is best for beginners as it can cinch down on your fingers as you swing. LED Pixel poi and glow poi are pixelated LEDs, in which the individual LEDs are programmable.
What is Poi Spinning? Poi spinning is a flow art that involves swinging tethered weights in a variety of rhythms and motions to create geometric patterns of light or color. This unique combination of performance art and dexterity play tends make spinning poi feel like an improvisational dance or meditative flow state.
The performance of writing large files with POI can be heavily reduced if you used the 'streaming' POI API instead of the standard one. Indeed by default POI will keep all your data in memory before writing all in one go at the end. The memory footprint of this can be ridiculously large for big files. Instead using the streaming API you can control how memory is used and data is written to disk progressively.
In order to create a streaming workbook, use something like :
SXSSFWorkbook book = new SXSSFWorkbook(); book.setCompressTempFiles(true); SXSSFSheet sheet = (SXSSFSheet) book.createSheet(); sheet.setRandomAccessWindowSize(100);// keep 100 rows in memory, exceeding rows will be flushed to disk // ... I would be very surprised to see POI take that much time to generate such a file. I just generated a sheet with 30000 rows x 10 cells in about 18s (no formatting, to be fair). The cause might be one of the following:
27
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
