Igor Sereda created DERBY-5980:
----------------------------------
Summary: Extremely slow roll forward when booting database that
wasn't properly closed
Key: DERBY-5980
URL: https://issues.apache.org/jira/browse/DERBY-5980
Project: Derby
Issue Type: Bug
Affects Versions: 10.9.1.0
Environment: Windows 7, Embedded mode
Reporter: Igor Sereda
Reproduction sequence:
1. Open database in embedded mode
2. Run a considerably large transaction - for example, one that creates 10 - 20
MB of db logs
3. Commit
4. Do NOT close the Connection
5. Exit the application (through System.exit() for example)
6. Restart the application and open the database
Observed:
Opening connection is extremely slow. It takes up 30- 60 seconds on the 10-20
MB transaction, and for larger transactions it takes forever.
Looking at the process with FileMon utility, I can see that redo log files are
mostly read *1 byte at a time*. :(
I bet you can improve the performance 100-fold by getting the whole log into
memory first.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
