H2 (as used by Eclipse EMF CDO) performance problem.

[Carel Bast]

Hi,

We are experiencing some big performance problems with Eclipse-CDO/H2 that we can not explain.

Our database contains a lot of small rows, that are extensively added/removed and changed.

After 5 or 6 hours heavy load on the database, when the database has grown to > 25 GB, we run into a problem that it looks like small changes in the database results in a very long processing time.

The database starts to changing hundreds of .log.db files (i.s.o. 1, 2 or 3) for one single update (or select).

Unfortunately we were not able to exactly point to the SQL statement(s) that causes the problem.

But we are repeatedly firing the same kind of SQL statements to the database and it looks like if we run into problems when the database exceeds a certain size.

Does this sounds familiar to one of you?

I will try to investigate further what statement is exactly causing the problem. But if this sounds like a know problem I will be very pleased to hear this.

Thanks in advance for your response!

Greetings,

-- Carel

[Carel Bast]

BTW: Eclipse / CDO is still using H2 version 1.1.117 

[Thomas Mueller]

Hi,

> hundreds of .log.db files (i.s.o. 1, 2 or 3)

It seems you are using a very old version of H2 (from 2009 I guess). I
suggest upgrading to the latest version. I will not be able to help
otherwise I'm afraid.

Regards,
Thomas

[Carel Bast]

Hi Thomas,

Thanks for you answer.

Unfortunately 1.1.117 is the only version officially supported in Eclipse (CDO).

But we managed to (unofficially) add the latest version of H2 (1.3.163).

We will test with this version and let you know what our experiences are..

Thanks,

-- Carel