On 2012-07-05 12:25, Steve McLeod wrote:
I've also experienced this slowness when dropping a large table. I
spent a considerable amount of time with the H2 source code trying to
find a way to speed things up, but alas it turns out not to be an easy
task with the current data store.
Hmm, you're right, that code path is pretty deep and winding.
starts here
DropTable#executeDrop()
which calls
Database#removeSchemaObject(...)
which calls
DbObject#removeChildrenAndResources(Session)
which means it's actually calling
RegularTable#removeChildrenAndResources(Session)
which calls
Index#remove(Session)
which means it's actually calling
PageDataIndex#remove(Session)
which calls
PageDataIndex#removeAllRows()
which calls
PageData#freeRecursive()
Can you run a profiler across the code and see where in this call stack
it is spending the bulk of it's time?
--
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.
