Yes, we use LOG=2 It obviously helps, but when the log file gets big, it still takes several minutes to work through it.
On Oct 31, 11:26 am, "Thomas Mueller" <[EMAIL PROTECTED]> wrote: > Hi, > > > Would that be possible to make a change so that MAX_LOG_SIZE can also > > be specified in kilobytes? Something like, if the value ends in 'K', > > it means kilobytes, Nothing or 'M' at the end means megabytes. > > I would rather solve the performance problem. > > > SET MAX_LOG_SIZE=1 // setMaxLogSize(1 megabyte) > > SET MAX_LOG_SIZE=1M // setMaxLogSize(1 megabyte) > > SET MAX_LOG_SIZE=64K // setMaxLogSize(64 kilobytes) > > > Our system can be very slow at startup when the database doesn't get > > shut down correctly, and the log accumulates a large number of items. > > We think that performing more frequent checkpoints will help in that > > aspect. > > Do you use SET LOG 2? Seehttp://www.h2database.com/html/grammar.html#setlog > > Regards, > Thomas --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
