Hello Aviar, Since you do not care about reliability, I guess that the settings described for fast database import could also apply to your use case as well:
http://www.h2database.com/html/performance.html#fast_import For more information on each parameter have a look at: http://www.h2database.com/html/grammar.html e.g: For LOCK_MODE : http://www.h2database.com/html/grammar.html?highlight=SET%2CLOCK_MODE&search=SET%20LOCK_MODE#set_lock_mode Using the site's search function will also point you faster to parts of the documentation, as Thomas has done a remarkable job with the documentation as well. Regards, Panayiotis On Mon, Mar 28, 2011 at 12:25 PM, Aivar <[email protected]> wrote: > Hi > > I plan to use H2 for caching intermediate results from an analysis, > and it's not big deal if data gets occasionally corrupted. > > What are my choices for trading reliabilty for efficiency? > > So far I was using HSQLDB, but I wanted to try H2 as it is said to be > faster. Probably I'm doing something wrong, because currently my > program runs bit faster with HSQLDB than with H2. > > When creating HSQLDB database, I issue following extra 2 commands, > that are not recognized by H2: > SET FILES LOG FALSE; > SET DATABASE DEFAULT TABLE TYPE CACHED; > Otherwise I'm using same script for creating both H2 and HSQLDB > databases. > > I could reduce speed difference by giving bigger cache for H2 (with > default settings, the speed difference between H2 and HSQLDB seemed to > be around 30%), but even with bigger cache (twice the size of db file) > H2 is still bit slower (about 10%). > > Aivar. > > > -- > 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.
