Performance with MySQL database

[renekonrad]

Hello,

we are currently using Version 13.5 of the Enterprise Architect.
We got several different projects. All of them are at least 10 years old. Two years ago we changed from using the Project files ".eap" to using a MySQL database - in that way all of our teammates can work on the same Project at a time.
Anyway we got a serious performance issue at the moment. The Folder structure is loading and working very fast. As soon as we click on the little arrow in front of any element it immediately opens the structure beneath it.
But when we click on a diagram it takes a few seconds until we can click again. When we want to open a diagram it sometimes takes even more time. And every time we open a diagram the Enterprise architect freezes for several seconds and Windows is asking us if we want to close the software.
We already tried to Change database Settings, but everything we configured hasnt result in better Performance.

Do you have any suggestions for us? The Support doesnt really help - it only wants to sell its Cloud solution.
Thanks in advance!

[Geert Bellekens]

Hi,

Thinks to consider:

- network: EA executes hundreds or even thousands of tiny a second. Often the network bandwith or latency can be a bottleneck
- Server config: I don't know anything about configuring database servers, but make sure it is optimized for this type of usage (e.g. lots of tiny inexpensive queries rather then small amounts of heavy expensive queries). Typically a MySQL database should be ideal for this type of usage seeing that this is very often used as the backend of a website.
- shape scripts: could slow down things a lot, especially if using add-in functions
- model views: some model views can be set to automatically refresh, which might be slowing down things
- add-ins: make sure to disable all add-ins and see if that makes a difference
- auditing: could have an impact as well
- diagram size: I've seen diagrams with thousands of elements on them. Those will be slow on any system. Don't do that unless you are in the wallpaper manufacturing business.
...

Geert

PS. Cloud server will probably not perform better in a LAN setup. It might help in a WAN config.

[PeterHeintz]

Sounds similar to that issue:
http://www.sparxsystems.com/forums/smf/index.php/topic,38153.msg237630.html#msg237630
I had.

However it was on a eap file connected to svn.
My analysis showed that it was not an svn issue and more an issue of my personal machine.

I got a workaround by doing frequently “Compact EAP File...”, sometime later the problem was gone!?!

[qwerty]

Peter, not expanding a new thread here, but it could have been connected with a bad sector on spinning rust (assuming you don't have a SSD). After some time this sector is no longer allocated and things run smoothly again.

q.

[PeterHeintz]

No, I have SSD and also copying to another drive did not help.
However it appeared and disappeared after some month. Maybe my VirusScanner.

Currently I am just happy that it is gone.

[renekonrad]

@PeterHeintz: your Problem is completely different from ours. We don't use EAP-Files. The local machine is also not a Problem, because we used several different Computer to work with Enterprise Architect.

@Geert Bellekens: Thanks for your help and ideas. Unfortunately I was able to exclude a few points. I tried the other Points but wasn't successful. The Performance is still poor. 

Do you know any tool that can test my connection to the database?

[Geert Bellekens]

No sorry, don't know of any tools that might be of help.

Geert

[qwerty]

Probably you could find some benchmark tools to test it. Or you write a small one which issues lots of tiny and a few large queries (on client and on server side) to trace the problem down. But you'd best be served with a local DBA or MySQL expert at your premises.

q.