Hi Thomas,
When running TRUNCATE TABLE on a large table, it is time-consuming. I've
done some profiling of the H2 source, and found that a step in
PageStore.checkpoint() that consumes one-third of the time needed for
TRUNCATE TABLE. In my specific case it uses 69 seconds out of seconds for
the whole TRUNCATE execution.
This line is the one consuming the time:
file.readFully(test, 0, 16);
which is org.h2.store.PageStore.java: line 451 in the current SVN trunk.
It is part of a process of zeroing freed pages on disk. I'm wondering if
zeroing is an important part of the workings of the PageStore. Or is it for
security reasons? If so, is this step something I could potentially make
optional by introducing a "INSECURE_FREE" database option?
I'm running on Mac OS X Lion, using an SSD drive.
Regards,
Steve McLeod
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/KpuvExBPO2sJ.
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.
