Hi, > Is it possible to initialize the database file to a certain > size or to somehow increase the > "resize size" so h2 doesn't resize it too often?
There is a special algorithm in place that should prevent the database file to resize too often (up to some point, it grows 50% at a time I think). Regards, Thomas On Fri, Dec 6, 2013 at 1:45 PM, Wickman <[email protected]<javascript:_e({}, 'cvml', '[email protected]');> > wrote: > > > Den fredagen den 6:e december 2013 kl. 11:34:02 UTC+1 skrev Noel Grandin: > >> >> >> On 2013-12-06 11:26, Wickman wrote: >> > >> > CREATE TABLE logs(id INT PRIMARY KEY AUTO_INCREMENT, message CLOB >> > >> >> Unless your data is truly large, try just using a VARCHAR for the message >> column. >> > > Yes, VARCHAR makes an improvement (2x in fact). > > Now since this is a queue, there will be lots of small continuous INSERTS > which causes the db file to increase. Resizing the file takes some time > obviously. > > Is it possible to initialize the database file to a certain size or to > somehow increase the "resize size" so h2 doesn't resize it too often? > > -- > 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] <javascript:_e({}, > 'cvml', 'h2-database%[email protected]');>. > To post to this group, send email to > [email protected]<javascript:_e({}, 'cvml', > '[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.
