tags:

views:

140

answers:

1
Q: 

H2 datastore EXTREMELY slow!!!

I just tested the H2 datastore (with Datanucleus 2.x)

The performance is VERY slow. 1/3 of Postgres and 1/10 of MySQL (aprox.)

I was very pleased by the "specs" but i cannot see them in "real usage". http://www.h2database.com/html/performance.html

Is there any performance tuning that i might be missing?

NOTE: even when accessing "our" database from the web interface it freezes for 5 seconds before presenting the tables.

thanks.

+4  A: 

Sounds like you have a host lookup problem; 5 seconds is a typical DNS timeout.

Holger Hoffstätte  2010-10-11 10:43:34

related questions

MySQL performance optimization: order by datetime field
How do I bulk upload to s3?
How to make visual studio 2008 ASP.NET designer faster?
High latency using brctl, eventual timeout.
Howto Speedup Visual Studio(2005/2008) Toolbox initialization
Tips for using vim over a slow connection?
Tips for improving this slow mysql query?
Showing tab with lots of ComboBox controls is slow with WinForms
What's wrong with this query? EXPLAIN looks fine to me...
MySQL "SET NAMES" near the top of the slow query log
Why is Linq to Xml so slow on Vista?
Telerik RadGrid working examples
WinForms ReportViewer: slow initial rendering
.NET C# drawing slowly
Why is F10 so slow in VS2008 ?
opengl slow on texture blit
(ASP.NET MVC) Will this make my webapp slow if I use GlobalResources for localization only?
Subversion Ant update task taking forever
glGetError hangs for several seconds
Using OOP for combining lots of functions (sort of namespace) in PHP?
Sharepoint site takes a while to load first thing in the morning
Why does Log4Net run so slow in my Windows Service?
gdi+ Graphics::DrawImage really slow~~
In a WPF ListBox with more than 1000 Image Items the Zoom Images become slow
How to change slow parametrized inserts into fast bulk copy (even from memory)