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