You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by pengbo <pe...@bii.a-star.edu.sg> on 2003/12/08 08:50:10 UTC
Memory limits
Hi , all
I have a question concerning the POI memory. Say, I have 1, 000 rows to load
by HSSF, Is it possible?
Thanks
Pengbo
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: Memory limits
Posted by Rommel Sharma <ro...@mahindrabt.com>.
Ref: POI Memory
If you are using the usermodel API then the entire data is first loaded onto
the memory. We did some tests, and found out that your program may throw out
of memory exception for large files, for which we have to explicitly
increase the JVM heap size using Command line options while running the
program.
The same when done using the eventmodel API that streams the data instead of
loading it first onto the memory, was more than 10 times faster, occupied
lesser memory by 10 times or more. However the ease with which we can go
back and forth, or to a specific location in and excel sheet using the
usermodel API is not possible with the event one and we have to do the extra
coding for that.
Rommel.
----- Original Message -----
From: "pengbo" <pe...@bii.a-star.edu.sg>
To: "POI Users List" <po...@jakarta.apache.org>
Sent: Monday, December 08, 2003 1:20 PM
Subject: Memory limits
> Hi , all
>
> I have a question concerning the POI memory. Say, I have 1, 000 rows to
load
> by HSSF, Is it possible?
>
> Thanks
>
> Pengbo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
> **************************************************************
> Scanned by eScan Content-Security and Anti-Virus Software.
> Visit http://www.mwti.net for more info on eScan and MailScan.
> **************************************************************
>
>
**************************************************************
Scanned by eScan Content-Security and Anti-Virus Software.
Visit http://www.mwti.net for more info on eScan and MailScan.
**************************************************************
*********************************************************
Disclaimer
This message (including any attachments) contains
confidential information intended for a specific
individual and purpose, and is protected by law.
If you are not the intended recipient, you should
delete this message and are hereby notified that
any disclosure, copying, or distribution of this
message, or the taking of any action based on it,
is strictly prohibited.
*********************************************************
Visit us at http://www.mahindrabt.com
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
AW: Memory limits
Posted by "karl-heinz (SAW)" <ka...@sawag.com>.
Hi Pengbo.
I've never read about restrictions of the POI memory. The Java memory
(without reconfiguring) is restricted to 64 MB and can be rised a lot.
So I think you'll not have problems which can't be solved by
reconfiguring.
MfG
Karl-Heinz Zengerle
___________________________________________________
More than competence in Document Management
___________________________________________________
SAW AG
Waldmünchenerstr. 12
81549 München
Tel.: ++49-89-68088368
Fax: ++49-89-68088389
www.sawag.com
___________________________________________________
-----Ursprüngliche Nachricht-----
Von: pengbo [mailto:pengbo@bii.a-star.edu.sg]
Gesendet: Montag, 8. Dezember 2003 08:50
An: POI Users List
Betreff: Memory limits
Hi , all
I have a question concerning the POI memory. Say, I have 1, 000 rows to
load
by HSSF, Is it possible?
Thanks
Pengbo
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
AW: Need Assistants.
Posted by "karl-heinz (SAW)" <ka...@sawag.com>.
Hi Wahab.
Directly in the POI page there's a sample project called HSSF. For me it
was also the sample for stepping into POI.
MfG
Karl-Heinz Zengerle
___________________________________________________
More than competence in Document Management
___________________________________________________
SAW AG
Waldmünchenerstr. 12
81549 München
Tel.: ++49-89-68088368
Fax: ++49-89-68088389
www.sawag.com
___________________________________________________
-----Ursprüngliche Nachricht-----
Von: Abdul Wahab [mailto:awahab@erp21.com.my]
Gesendet: Montag, 8. Dezember 2003 10:30
An: POI Users List
Betreff: Need Assistants.
Hi All,
I'm new to POI. Actually my requirement is to search the particular text
in
varity of files(atleast in doc, xls, pdf, rtf, txt) using java based
parsers. I found you all working with this POI to read and write. Since
we
can read doc and xls file using this POI thats enough for timebeing for
me.
But the problem is...... I dont get the basic idea to implement this
POI.
Can you help me by giving any simple sample program for read and write..
And if you know any other technologies for java based text search also
let
me know.
Thanks for your great help.
Wahab.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: Need Assistants.
Posted by Nick Burch <ni...@torchbox.com>.
On Mon, 8 Dec 2003, Abdul Wahab wrote:
> But the problem is...... I dont get the basic idea to implement this
> POI. Can you help me by giving any simple sample program for read and
> write..
I'm using 2.0 r3, and I found the examples + the JavaDoc more than enough
to get me started. Make sure you grab the source as well as the binaries,
then go looking in src/examples/src/org/apache/poi (excel and document
properties) and src/scratchpad/src/org/apache/poi/hdf/extractor (word).
Also, the root of /doc/ from a distribution has a lot of useful
information in it
> And if you know any other technologies for java based text search also
> let me know.
I use Lucene (http://jakarta.apache.org/lucene/docs/index.html) - it only
accepts plain text, so I use POI to convert to plain text, and feed that
in. Works a treat
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Need Assistants.
Posted by Abdul Wahab <aw...@erp21.com.my>.
Hi All,
I'm new to POI. Actually my requirement is to search the particular text in
varity of files(atleast in doc, xls, pdf, rtf, txt) using java based
parsers. I found you all working with this POI to read and write. Since we
can read doc and xls file using this POI thats enough for timebeing for me.
But the problem is...... I dont get the basic idea to implement this POI.
Can you help me by giving any simple sample program for read and write..
And if you know any other technologies for java based text search also let
me know.
Thanks for your great help.
Wahab.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org