Thanks for the tip about the zip. I will try that next. I tried splitting the data into three databases with the largest being 14GB and that seems still too large for the machines to handle. Based on the research I did it seems that the machines are running out of non paged Kernel memory during the connection open. The MS bulletins I saw regarding the problem were hinting at a possible memory leak to eventually fill up the Kernel, but I don't know if that is the case here.
Do you see any problem with keeping all three databases in the same zip file and reading from there? Also, on average what do you think will be the performance hit for keeping it all compressed? Thanks so much for your help. Yeah, based on the searches I know that it is an OS related problem. On Dec 17, 6:22 am, Thomas Mueller <[email protected]> wrote: > Hi, > > I never heard about this problem. You probably already know that > "Insufficient system resources exist to complete the requested > service" is from the OS and not from H2, and I guess you have already > done a Google search (just to make sure). > > If the problem is the file size, then you could try using the 'split' > file system:http://www.h2database.com/html/advanced.html#file_system > - please tell me if this helps! > > Regards, > Thomas -- 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.
