I looked back at my work on this some months ago, and actually it was with
TRUNCATE TABLE that I did my investigation. You can read the discussion about
this here:
https://groups.google.com/forum/?fromgroups#!topic/h2-database/jUqGLVL1FeE
I posted there the following:
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.
On Thursday, 5 July 2012 at 8:19 PM, Noel Grandin wrote:
>
> 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.
