Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » [CDO] CDO DBSTORE Performance with bigger databases
[CDO] CDO DBSTORE Performance with bigger databases [message #793546] Wed, 08 February 2012 09:21 Go to next message
Carel Bast is currently offline Carel BastFriend
Messages: 16
Registered: November 2009
Junior Member
Hi All,

(This is more or less the same question as Christophe Bouhier asked earlier)

We currently use H2 as DBSTORE of CDO.

We seem to run in all kinds of scalability issues as soon as the
database gets bigger (> 20GB).

- Do the other DBSTORE implementations have better scalability?

- Do you have experience with using CDO with 'big' databases?

- Anyone did try to use a newer version of H2 with CDO?

Greetings,

-- Carel
Re: [CDO] CDO DBSTORE Performance with bigger databases [message #793651 is a reply to message #793546] Wed, 08 February 2012 11:47 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6682
Registered: July 2009
Senior Member
Am 08.02.2012 10:21, schrieb Carel Bast:
> Hi All,
>
> (This is more or less the same question as Christophe Bouhier asked earlier)
>
> We currently use H2 as DBSTORE of CDO.
>
> We seem to run in all kinds of scalability issues as soon as the database gets bigger (> 20GB).
>
> - Do the other DBSTORE implementations have better scalability?
Given that H2 is free and DBMSs from Oracle, IBM, etc. cost lots of money, I would expect that they scale better.

>
> - Do you have experience with using CDO with 'big' databases?
Personally I have almost no experience in operating DBMSs. It would be great to hear from others about their experiences!

>
> - Anyone did try to use a newer version of H2 with CDO?
Not me, but I don't foresee general issues. We only use this old version of H2 to build against because it's the only
one in Orbit: http://download.eclipse.org/tools/orbit/downloads

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper


Re: [CDO] CDO DBSTORE Performance with bigger databases [message #794553 is a reply to message #793546] Thu, 09 February 2012 12:36 Go to previous message
Stefan Winkler is currently offline Stefan WinklerFriend
Messages: 307
Registered: July 2009
Location: Germany
Senior Member
Am 08.02.12 10:21, schrieb Carel Bast:
> Hi All,
>
> (This is more or less the same question as Christophe Bouhier asked
> earlier)
>
> We currently use H2 as DBSTORE of CDO.
>
> We seem to run in all kinds of scalability issues as soon as the
> database gets bigger (> 20GB).
>
> - Do the other DBSTORE implementations have better scalability?

As Eike said, I think that commercial systems scale better for larger
DBs. At least you have more options to tweak them to your needs (e.g.
partitioning of tables etc).

> - Do you have experience with using CDO with 'big' databases?

Not in that size, no.
There is a rather new performance measurement framework in the test
suites. If you can model your specific needs in single test cases, you
can use it to analyze performance with different stores and different DBMS.

I have done so with Postgres and Mysql, but only with default settings
and small databases. Under these settings, Postgres seems to be a bit
faster than MySQL. But then, the Postgres support in CDO misses a few
features (search Bugzilla for CDO postgres bugs for details).
And in these cases, H2 still outperforms both IIRC.

> - Anyone did try to use a newer version of H2 with CDO?

I did a performance comparison once between h2 1.1.117 (which is
included in Orbit) and the most current version (this was in december).
The more current version is certainly faster in some cases. Maybe there
should be an initiative to get the current version into Orbit. Until
then you should try and create an OSGi bundle for yourself.

Also, general performance is hard to optimize. You can always optimize
for specific scenarios (e.g. with different mapping strategies, database
configuration options, special indexes etc.). So, you should be more
specific which part of the performance you want to optimize.

Cheers,
Stefan
Previous Topic:[Teneo/Hibernate/GMF] DuplicateMappingException => QualifyingEntityNameStrategy => Ill
Next Topic:EMF and Schematron
Goto Forum:
  


Current Time: Fri Mar 29 05:47:18 GMT 2024

Powered by FUDForum. Page generated in 0.02111 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top