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.
