On Sep 10, 2009, at 5:52 AM, Nuno Seco wrote:

>
> Hi.
>
> I have a project I'm working on where I load WordNet into a h2
> database.
> I changed to version 1.1.118 this morning and its REALLY SLOWER
> inserting the data.
>
> The only thing I've changed was the h2 jar file. I'm back to using
> version 1.1.117.
>
> Anyway just wanted to share that piece of information.

<sigh> What a useless report.

What Java VM? Version? What command-line options do you use to start  
it up?

How much cache is allocated to H2? Do you set any other H2 options?

What is your table structure? Which column(s) have indexes?

Give us the SQL for your insert.

Are you using PageStore or the original file format?

This isn't even an exhaustive list of details you can and should  
share. Feel free to expand on this.

If you provided more information, folks with knowledge of the code and  
the specific changes that occurred between 1.1.117 and 118 could get  
to fixing it.

cr


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to