Hi Christoph, Thanks for your suggestion.
I tried to use dev/shm in linux machine to populate more data using in- memory database. But was able to load only 1 million data only.after that i get JDBCException "OutOfMemoryError: GC overhead limit exceeded". I tried these below steps: 1)install db under dev/shm 2)started server from this directory in one process 3) loaded data(using .csv file read) from same machine with another process. Can you please help me out if there is anything I am missing when i use dev/shm directory. or kindly tell me if in-memory db can hold more data(approx 160 million data ) Thanks in advance. Regards, Karun On Jan 5, 5:32 pm, Karun <[email protected]> wrote: > Hi > > Thanks for quick reply. > > Regards, > Mohanty > > On Jan 4, 11:17 pm, Christoph Läubrich <[email protected]> wrote: > > > > > > > > > If you are running on Linux you can "store" the db in the special > > /dev/shm device which is in fact a (shared) memory disk, access to this > > device is really fast and you even don't waste any java heapspace. One > > nice thing is, when you run out of memory it autmatically uses the > > swapspace if I rember right. > > > Am 04.01.2012 18:42, schrieb [email protected]: > > > > There was a suggestion some time ago about using a RAM disk as db > > > storage as an alternative to in-memory database. An advantage will be > > > that you should not worry about GC, but it will still be slower that a > > > plain in-memory db. Maybe, the nio stuff in H2 can alleviate that. > > > > Otherwise.. the problem with hard questions is that they have no > > > obvious questions. > > > > -- > > > Vasile Rotaru > > > -- > > > 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. -- 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.
