Java will typically consume as much memory as there is available on the system.
If you want it reduce it's memory usage, then you need to explicitly tell it to 
limit itself.

For example
   java -XMx=250M
will tell java to limit itself to less then 250M.


vsaji wrote:
> Hi Noel,
>
> I tried your suggestion but not much luck.
> Let me put my question this way. If I want to load 1million records
> (with 10 cols) and avg record size 500 byte using file method. How
> much memory is expected to be consumed.
> I am trying to achieve using 1GB,is it possible ? if yes, how should
> my jdbc url look like.
>
> From this url, I found the following information. But it doesn't seems
> to be working.
> http://www.h2database.com/html/advanced.html?highlight=split&search=%3Asplit#limits_limitations
>
> "Main memory requirements: The larger the database, the more main
> memory is required. With the version 1.1 storage mechanism, the
> minimum main memory required for a 12 GB database was around 240 MB.
> With the current page store, the minimum main memory required is much
> lower, around 1 MB for each 8 GB database file size"
>
> Pleas help.
>
> Saji
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to