Author Topic: Recommended DBMS System (Read 4705 times)

ApelManu · « **on:** April 04, 2013, 03:01:38 am »

Hi all,

what's the recommended DBMS System for EA?
- MS SQL Server
- MySQL
- Postgres
- Oracle

Hope someone has any experience about the DBMS systems. I would prefer MS SQL Server.

Thanks Manu

qwerty · « **Reply #1 on:** April 04, 2013, 04:32:05 am »

Take what your DBA recommends.

MySQL is working nicely, though I heard Postgres seems to be okay too. Only for Oracle I have heard a couple of complaints about performance.

q.

Sunshine · « **Reply #2 on:** April 04, 2013, 07:08:06 am »

I've used SQL with no problems. Heard MySQL works well from a colleague in another organisation. Had some issues with Oracle which is my organisation's preferred database. You'll need a good DBA to ensure everything works okay so take what they are skilled in unless its Oracle

ApelManu · « **Reply #3 on:** April 04, 2013, 05:20:20 pm »

Thanks for the fast reply. Think im going to use MS SQL.

Geert Bellekens · « **Reply #4 on:** April 04, 2013, 05:52:51 pm »

We use MS SQL as well, and a former client of me used Oracle.
I guess it all boils down to the quality of the DBA, not of the DBMS

Geert

SomersetGraham · « **Reply #5 on:** April 04, 2013, 06:16:22 pm »

+1 for MS SQL

Helmut Ortmann · « **Reply #6 on:** April 04, 2013, 10:38:02 pm »

Oracle has at least one nasty error.

alvarodal11 · « **Reply #7 on:** April 21, 2013, 11:42:05 am »

Could you please expand your comment on EA x Oracle issues ?

Helmut Ortmann · « **Reply #8 on:** April 22, 2013, 01:33:18 am »

When EA makes a query with more than 1,000 elements in an 'in' (in 1,2,3,4,...) clause Oracle fires an error (Oracle 10,11).

In our caste it's nasty because this happens within a Checkout operation of EA.

According to Oracle this is to prevent the system from unpredictable performance. They don't intend to change this feature.

By the way: Other DBMSs like SQL Server are a lot faster than Oracle in an environment with EA. Projects which wanted a DBMS checked performance of Oracle in detail and after a while they convinced the IT not to use Oracle (wasn't easy).

Best regards,

Helmut

Geert Bellekens · « **Reply #9 on:** April 22, 2013, 04:38:59 pm »

In general EA will fire lots and lots of small queries to the database when you are doing modelling.
It is interesting to setup some kind a logging/tracing to get an idea, it sometimes goes up to more then 10 queries a second.

Whatever DBMS deals best with this type of usage will be best for EA.

Geert

KP · « **Reply #10 on:** April 22, 2013, 04:45:15 pm »

Quote

When EA makes a query with more than 1,000 elements in an 'in' (in 1,2,3,4,...) clause Oracle fires an error (Oracle 10,11).

We split Oracle queries wherever necessary to avoid this 'in clause' limitation, but if you find one that we have missed, please report it and we will fix it up.

Ian Mitchell · « **Reply #11 on:** April 22, 2013, 05:56:04 pm »

Also, the EA Schemas for SQL Server and Oracle are slightly different. In general, the Oracle seems to be stricter (for no obvious reason - probably just a typo in the Sparx creation script), which causes problems for us poor Extension writers.
So I'm voting for SQLServer as well.

Sparx Systems Forum

News: