Author Topic: DBMS recomendations  (Read 859 times)

yonatan.lehman

  • EA User
  • **
  • Posts: 47
  • Karma: +0/-0
    • View Profile
DBMS recomendations
« on: August 08, 2022, 03:28:16 pm »
Hi
We are considering moving from EA14 with eaxp files over VSN to EA16 with a DBMS server.

Can anyone recommend a preferred DBMS  - or alternatively recommend to continue working with SQLite file repository over VSN  - or perhaps we should be looking at the proCloud solution ?

I'm looking for speed and trouble free operation. We're about 6 people modeling a system which will eventually grow to about 1000 modules (components) and 10000 Activities.

The options provided by Sparx is:
  • Firebird from v2
  • MySQL from v5
  • MariaDB
  • Microsoft SQL Server from 2005, all editions including Express and Azure SQL Database
  • Microsoft Access from 2007
  • Oracle from 9i (all editions)
  • PostgreSQL from v8
Thanks !
« Last Edit: August 08, 2022, 03:34:06 pm by yonatan.lehman »

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1211
  • Karma: +108/-10
  • Its the results that count
    • View Profile
Re: DBMS recomendations
« Reply #1 on: August 08, 2022, 05:00:51 pm »
The documents on model-repositories should provide you with some guidance on best practices
https://sparxsystems.com/resources/user-guides/16.0/index.html#model-repositories
Usually 5 or less users you can get away with a file based repository otherwise consider going to a server based DB.
SQL Lite is new with V16 so not much experience with that however, early tests indicate it appears to be pretty good. Also had good experience with MSSQL and MySQL.
Cloud Pro server is good to use and if you want even more collaboration features then consider prolaborate.
All depends on budget of course.
Another factor to consider is whether any of the team have any experience with any of the database technologies.
Avoid Oracle its performance with Sparx EA is poor.
Happy to help
:)

wivel

  • EA User
  • **
  • Posts: 150
  • Karma: +11/-1
  • Driven by Models
    • View Profile
Re: DBMS recomendations
« Reply #2 on: August 08, 2022, 07:52:30 pm »
Hi

Just to add a few comments to Sunshines already excellent answer.
  • Do not use Oracle
  • At a previous assignment, I tried to do a little benchmarking between direct MS SQL Server connections and connection to the same database via PCS, and didn't see any performance benefits using PCS. I did however get timeout issues with PCS mainly during import/export and copy/pasting packages
  • PCS is needed if you want to use WebEA, otherwise not
  • Since SQLite is a 'real' SQL database, compared to Access, I think you will be fine with 6 users. But as Sunshine mentions, its still early days for it and EA 16
  • I have mainly used MS SQL Server and have good experience with it. Locally I am running SQL Server Express to stay on a database I am comfortable with

Let us know what you decide.

Henrik 

yonatan.lehman

  • EA User
  • **
  • Posts: 47
  • Karma: +0/-0
    • View Profile
Re: DBMS recomendations
« Reply #3 on: August 09, 2022, 12:08:26 am »
Can I expect any latency issues when working with a DBMS assuming a reasonable bandwidth home connection of say 100Mbit?

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1211
  • Karma: +108/-10
  • Its the results that count
    • View Profile
Re: DBMS recomendations
« Reply #4 on: August 09, 2022, 12:45:08 pm »
Depends on network and server latency.
I use Sparx EA with a backend SQL Server from home over a fibre network to corp DB server without issues.
Happy to help
:)

wivel

  • EA User
  • **
  • Posts: 150
  • Karma: +11/-1
  • Driven by Models
    • View Profile
Re: DBMS recomendations
« Reply #5 on: August 09, 2022, 09:12:07 pm »
Can I expect any latency issues when working with a DBMS assuming a reasonable bandwidth home connection of say 100Mbit?
It depends on what you do. My experience is that regular modeling will be fine, but large exports/imports and data transfers will be slower and timeouts may occur.

Henrik

Michael Mangelschots

  • EA Novice
  • *
  • Posts: 18
  • Karma: +1/-0
    • View Profile
Re: DBMS recomendations
« Reply #6 on: August 29, 2022, 05:26:11 pm »
We moved from Oracle to SQL Server and noticed a major performance improvement.
Working from home with EA directly connected to a database was very slow, I received a lot of complaints. We added the Pro Cloud Server and that solved the issue.