Author Topic: EA slow when using networked repo  (Read 4782 times)

MarcinG

  • EA User
  • **
  • Posts: 26
  • Karma: +0/-0
    • View Profile
EA slow when using networked repo
« on: July 09, 2021, 04:25:44 pm »
Hello ladies and gents,

we are using our EA with a network repository sitting somewhere on the server.  However, working this way is quite slow, as any diagram that's a bit more complex takes time to be pulled out of the repo.  Working with local files is not an option.  Would you happen to have any hints or suggestions on making it faster ?  Perhaps there is some kind of setting like caching that I am not aware of ?

Best regards
Marcin

PeterHeintz

  • EA User
  • **
  • Posts: 895
  • Karma: +55/-18
    • View Profile
Re: EA slow when using networked repo
« Reply #1 on: July 09, 2021, 04:34:24 pm »
Hi Marcin,
I assume that you are using a file bases eap or eapx file on a network drive, which is at the end a MS Access DB, right?
To get better performance you could e.g. setup or let setup an MS SQL server running you repository to have a propper client/server envionment.
Best regards,

Peter Heintz

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 11299
  • Karma: +421/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: EA slow when using networked repo
« Reply #2 on: July 09, 2021, 05:12:11 pm »
On a LAN using an database server such as SQL Server (not Oracle) is workable.

For even better performance (or remote setups) consider moving the EA client to a server as well. Use it using RDP or citrix

Geert

MarcinG

  • EA User
  • **
  • Posts: 26
  • Karma: +0/-0
    • View Profile
Re: EA slow when using networked repo
« Reply #3 on: July 09, 2021, 05:47:19 pm »
Hi Marcin,
I assume that you are using a file bases eap or eapx file on a network drive, which is at the end a MS Access DB, right?
To get better performance you could e.g. setup or let setup an MS SQL server running you repository to have a propper client/server envionment.
Hi PeterHeinz,
no, we are using a database repo (SQL Server in this case).  Still , opening any diagram takes a bit of time (about 30 sec, sometimes 15 secs)


Guillaume

  • EA Practitioner
  • ***
  • Posts: 1083
  • Karma: +34/-2
    • View Profile
    • www.umlchannel.com
Re: EA slow when using networked repo
« Reply #4 on: July 09, 2021, 05:59:37 pm »
Hi Marcin,

If you work remotely, switching your access to the Pro Cloud Server can improve performances.

Guillaume
Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com


bknoth2

  • EA User
  • **
  • Posts: 128
  • Karma: +2/-0
    • View Profile
Re: EA slow when using networked repo
« Reply #5 on: July 13, 2021, 01:45:12 am »
EA interacts with the database a lot and any latency in the network (due to routers, firewalls, etc) will make it painfully slow. We typically use Postgres backends and run into the same slowness problem (it can be unusable). We get around that problem by setting up virtual machines at the same location as the database server and use remote desktop to run EA on them. We have no significant performance issues with that configuration.

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1119
  • Karma: +103/-9
  • Its the results that count
    • View Profile
Re: EA slow when using networked repo
« Reply #6 on: July 13, 2021, 08:33:40 pm »
We have EA running off SQL server and it's fine most of the time. Have about 75K objects and 10K diagrams so it's not small. Diagrams open within few secs and complex ones about 10 sec. Occasionally network issues occur and it slows and that's not often. Have to resort to good old fashioned problem solving and the key is to find the cause. Once you know the cause it's usually easy to fix.
There are some good problem solving methods out there like kepner tregoe to help identify the cause.
Happy to help
:)

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 7984
  • Karma: +209/-127
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: EA slow when using networked repo
« Reply #7 on: July 13, 2021, 08:45:46 pm »
We have EA running off SQL server and it's fine most of the time. Have about 75K objects and 10K diagrams so it's not small. Diagrams open within few secs and complex ones about 10 sec. Occasionally network issues occur and it slows and that's not often. Have to resort to good old fashioned problem solving and the key is to find the cause. Once you know the cause it's usually easy to fix.
There are some good problem-solving methods out there like kepner tregoe to help identify the cause.
Kepner Tregoe - Now, there's a "blast from the past".  Must be at least 3 decades, if not 4 since I did the course!

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1119
  • Karma: +103/-9
  • Its the results that count
    • View Profile
Re: EA slow when using networked repo
« Reply #8 on: July 14, 2021, 05:40:48 am »
...
Kepner Tregoe - Now, there's a "blast from the past".  Must be at least 3 decades, if not 4 since I did the course!

Paolo

Yup saved my bacon a few times.  IIRC KT was developed in the 60's. Good enough to help NASA bring back Apollo 13 and referenced by  ITIL.
https://blogs.ed.ac.uk/itiltattle/2019/03/15/kepner-tregoe-demystified/

Happy to help
:)