Hi
We have been using H2 database with our application and very happy with it. We had some tables with upto 8 million records and it worked very well. Now We have a new requirement to load a table with 200 million records. What is the best way to handle this situation with H2 ? these are the reference data and we will query this millions of times. These are the current solutions we have been discussing so far, If we have to load all 200 million records then initial loading time will be more, every time when we start application, need to wait more. How about running H2 in server mode on a separate jvm? that will hit the network performance since we need to query this table millions of times over network. Does H2 support partitioning? should we break this table into multiple tables of each 20 million records and then load them on demand. Any one came across similar situation or any other solution to recommend? Any help in this is greatly appreciated. Thanks Shiva -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
