|
|
Re: [CDO] CDO DBSTORE Performance with bigger databases [message #794553 is a reply to message #793546] |
Thu, 09 February 2012 12:36 |
Stefan Winkler 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
|
|
|
Powered by
FUDForum. Page generated in 0.02111 seconds