On occasion, connecting to a large existing H2 database takes a long time (on the order of 5 to 10 minutes). This used to happen regularly for us, but it has now become a rare occurrence. Many thanks, Thomas, for work you've done in this area.
It appears that the long startup times occur when the database is in recovery mode during startup. If I connect to one of these databases with the H2 console, I'll see many messages of the form: Opening Database URL: jdbc:h2:C:\DataCache\h2\testDB User: sa Version: 1.0.77 (2008-08-16) 13:06:49.470: Start... 13:06:49.767: Recovering C:\DataCache\h2\testDB.48.log.db 0% 13:06:53.485: Recovering C:\DataCache\h2\testDB.48.log.db 1% 13:06:54.485: Recovering C:\DataCache\h2\testDB.48.log.db 1% 13:06:55.485: Recovering C:\DataCache\h2\testDB.48.log.db 2% 13:06:56.486: Recovering C:\DataCache\h2\testDB.48.log.db 2% 13:06:57.486: Recovering C:\DataCache\h2\testDB.48.log.db 2% 13:06:58.486: Recovering C:\DataCache\h2\testDB.48.log.db 3% 13:06:59.486: Recovering C:\DataCache\h2\testDB.48.log.db 3% 13:07:00.486: Recovering C:\DataCache\h2\testDB.48.log.db 3% and so on . . . I think that indicates that the database was not successfully shutdown on the previous run. Is that interpretation correct? Or can this occur in other situations? (We typically use an embedded database, and specify LOG=2;MVCC=TRUE on our connection strings.) Also, what influences the time for recovery? Is this mostly a factor of the number of rows added and deleted in the previous session? If we successfully committed or rolled back all transactions in the previous run, but failed to shutdown the database, would we still see a lengthy recovery time the next time we connected to the database? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
