Hi, The time to open a database should not depend on the size too much. How long does it take? Could you try using the "shutdown defrag" after writing (please note it is slow)?
> Does H2 support partitioning? Currently not, sorry. Regards, Thomas Am 07.07.2013 12:38 schrieb "Jan Kotek" <[email protected]>: > ** > > This is probably spam, but since nobody answered. > > Try MapDB, it is embedded db engine. It only has embedded mode and does > not have SQL. > > It imports 200 million records in a few seconds if Data Pump is used. > > Jan > > > > On Wednesday 26 June 2013 22:32:34 Shiva wrote: > > 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. > > > > > > -- > 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. > > > -- 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.
