One more question. Transaction log is stored on disk or in memory? My database is in file on disk, if that matters.
On Wednesday, March 27, 2013 8:59:55 AM UTC+1, Noel Grandin wrote: > > I'm not sure, I'd set it to about twice your max blob size. > > On 2013-03-27 09:51, Micha� Michalak wrote: > > Thanks for help. Still, my app is intended to work for days. I assume > increasing log size is short-time solution and it will overload again, > eventually. Please correct me if I'm wrong. > > I would appreciate few words about how does it work - how to determine > the optimum size. Should the size be bigger that one possible blob? > (Assuming I have enabled autoCommit.) > > MM > > > W dniu �roda, 27 marca 2013 07:53:17 UTC+1 u�ytkownik Noel Grandin > napisa�: >> >> Increase your maximum log size with: >> >> http://h2database.com/html/grammar.html#set_max_log_size >> >> On 2013-03-26 15:21, Micha� Michalak wrote: >> > Transaction log could not be truncated >> >> -- > 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:>. > To post to this group, send email to [email protected]<javascript:> > . > Visit this group at http://groups.google.com/group/h2-database?hl=en. > 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
