how are you doing the copy? Are you committing periodically, or only after the load is complete? If you commit only once, you are going to use a lot of memory. You need to be committing every 1000 rows or so.
vsaji wrote: > Hi Noel, > > Thanks for your response. > I did try the options stated in the URL, however, if I trace the > memory consumption of the process, it is still taking more memory > (Close to 2GB for loading 1million records with 6 columns) . What I am > not able to understand is, why file mode <jdbc:h2:file> consuming such > high memory. > > My program is simple and it populates record into H2 copying from a > Oracle. > > Any inputs ? > > Regards > 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.
