H2 doesn't have any automatic data partitioning support. If you're storing that much data and it's purely in-memory, why do you need a database? Would be less overhead to store it in an ArrayList or HashMap.
Also, at the scale, you are going to have significant GC pauses. You might want to check out the heap storage solutions like http://terracotta.org/products/bigmemory and memcached Karun wrote: > Hi, > > Hope you are doing well. Need your help on h2db. > > I am using h2db version 1.3.162 for my project. I would like to know > below details on h2db in-memory mode > > 1) Does h2db support data partitioning? > 2) If yes, then can you please tell me how it can be achieved > > > Note: Planning to store 160 million records per day in h2db in-memory > mode. > > Could you please help me in these matters. > > Thanks & Regards, > Karun > -- 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.
