I recently worked on a small project where I had to overcome these memory issues. I also based my final solution off BigGridDemo but with the addition of being able to work on multiple sheets. Since it was a relatively trivial and small program the solution was fairly hacked together, but I can foresee in the future that POI will be extremely valuable for projects in which memory concerns will also most likely be a concern. My question is, why do you not consider BigGridDemo a "solution"? Is it simply because it is not full featured production style code, or is it due to limitations or possible incompatibilities with how the usermodel currently works? I have only used POI on one other project and this was before there was even support for .xslx so my knowledge is fairly limited. But, from my understanding the memory issue lies within the library used to process xml, should memory footprint improvements be aimed at this library or would a more reasonable solution be to replace the library altogether in some way? I know these questions are fairly broad and probably do not have simple answers, I am just trying to get an idea of whether or not this is something within my capability to maybe work on in my spare time. I am encouraged at my job to contribute back to any open source projects I make use of and finally have the opportunity and motivation to do so. However, as I said before my experience with all the features of POI is limited and my knowledge of xml is fairly cursory so basically I doubt if I could do much better than the library being used. Sorry if these questions may have been more appropriately posted to the dev list but it seemed appropriate to the conversation.
On Wed, Oct 21, 2009 at 8:02 AM, Yegor Kozlov <[email protected]> wrote: > usermodel API is unlikely to change. All memory-related improvements will > be internal and upgrading to a newer version of POI will not be an issue. > > BigGridDemo.java is not a "solution", rather a prototype of a API with > low-memory footprint. Current version is very simple, it was developed only > to show the idea. > > > >> We have developed our own solution which is inspired by BigGridDemo and it >> is working fine. Also I have seen some other peoples are trying the same >> thing. With this approach maintainability will be a concern. Like for >> upgrade to newer version of POI. >> >> > Consider contributing your code to the POI project. It will boost the > development of this part of XSSF and you will also achieve maximum level of > compatibility with further versions of POI. > > Yegor > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
