Home » Modeling » EMF » [CDO] preferred DBStore DB vendor.
|
Re: [CDO] preferred DBStore DB vendor. [message #793656 is a reply to message #791260] |
Wed, 08 February 2012 11:54 |
|
Hi Christophe,
As I mentioned in my replies to Carel's posts, I don't have decent operational experience with DBMSs. I really hope that
others jump in here.
From a CDO perspective there doesn't seem to be important differences. The quality of the used net4j.db.IDBAdapter can
make a difference, though. Not all of them have been developed by me personally ;-)
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Am 05.02.2012 15:40, schrieb Christophe Bouhier:
> Hi,
> Which DB is best supported/ maintained by de CDO DB Store? The reason I ask, is because of some issues I have with
> PostgreSQL, and remarks made by the CDO team considering PostgreSQL.
> I would be nice to see some ranking, of CDO deployments and the used DBStore.
> thank you, Christophe
>
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
Re: [CDO] preferred DBStore DB vendor. [message #794642 is a reply to message #793656] |
Thu, 09 February 2012 14:30 |
Stefan Winkler Messages: 307 Registered: July 2009 Location: Germany |
Senior Member |
|
|
Hi Christophe,
CDO is tested best with H2 followed by MySQL. In my performance
measurements (I will blog about them some time and give a talk at
EclipseCon in Washington this year), I have found that PostgreSQL works
better performance-wise (if it works, that is).
The problem with PostgreSQL and other DB adapters is just one of time
and funding. I have the PostgreSQL bugs on my list, but I am currently
involved in other projects, so there is little time to iron out all the
Postgres issues.
Cheers
Stefan
Am 08.02.12 12:54, schrieb Eike Stepper:
> Hi Christophe,
>
> As I mentioned in my replies to Carel's posts, I don't have decent
> operational experience with DBMSs. I really hope that others jump in here.
>
> From a CDO perspective there doesn't seem to be important differences.
> The quality of the used net4j.db.IDBAdapter can make a difference,
> though. Not all of them have been developed by me personally ;-)
>
> Cheers
> /Eike
>
> ----
> http://www.esc-net.de
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
>
> Am 05.02.2012 15:40, schrieb Christophe Bouhier:
>> Hi,
>> Which DB is best supported/ maintained by de CDO DB Store? The reason
>> I ask, is because of some issues I have with PostgreSQL, and remarks
>> made by the CDO team considering PostgreSQL.
>> I would be nice to see some ranking, of CDO deployments and the used
>> DBStore.
>> thank you, Christophe
>>
|
|
| |
Re: [CDO] preferred DBStore DB vendor. [message #794678 is a reply to message #794666] |
Thu, 09 February 2012 15:10 |
Victor Roldan Betancort Messages: 524 Registered: July 2009 |
Senior Member |
|
|
Eike Stepper escribió:
> Am 09.02.2012 15:30, schrieb Stefan Winkler:
>> Hi Christophe,
>>
>> CDO is tested best with H2 followed by MySQL. In my performance
>> measurements (I will blog about them some time and give a talk at
>> EclipseCon in Washington this year), I have found that PostgreSQL
>> works better performance-wise (if it works, that is).
>>
>> The problem with PostgreSQL and other DB adapters is just one of time
>> and funding. I have the PostgreSQL bugs on my list, but I am
>> currently involved in other projects, so there is little time to iron
>> out all the Postgres issues.
> Maybe Vik wants to help out? IIRC he's done the PostgresqlAdapter
> initially.
We discarded PostgresSQL and MySQL long time ago due to performance
issues, and also ease of use. H2 seem to perform much better, so we
adopted H2 for our products.
I haven't reached 30gb database sizes (only several gigabytes), though,
so I can't say how well H2 scales. I'd be surprised if H2 didn't have
any support for clustering or so. Even if they scale better, H2 still
seems to be quicker at querying the database, so one should calculate
the trade-off (total throughput vs scalability, I guess).
Nevertheless, I could help out to polish Postgresql DBAdapter
implementation, not at the moment, next month I should have time for that.
Cheers,
Víctor.
|
|
| |
Goto Forum:
Current Time: Thu Apr 18 04:23:21 GMT 2024
Powered by FUDForum. Page generated in 0.02135 seconds
|