How to speed up EA

[marlow]

We have migrated rose model into an EA.  Repository is placed on MySql serwer.  After few months we have noticed that every operation on common repository (work group - 20 users) is taking much more time that before (model is getting larger and larger). Only working with local files (eap) is acceptable now. We've try to tune MySql to make DBMS operation faster but it isnt work. How can we speed up EA? Does anyone have any suggestion or recomendation how to solve this problem?

Marlow

[thomas.kilian]

Marlow,
http://www.sparxsystems.com.au/cgi-bin/yabb/YaBB.cgi?board=general;action=display;num=1099064702 is probably a different approach. I guess the speed problem is directly related to locking. If all of your staff is working in parallel on the same DB the number of locks will explode at a certain point. Probably it would be better to limit the number of concurrent accesses and use controlled packages or replicas.

[mikewhit]

If locking is indeed the issue, then checking out the MySQL docs on Locking Issues might be useful - but the only things you could change would be switching to InnoDB, to allow row locking, or running with the --low-priority-updates setting.

I guess Sparx could advise here in terms of the SQL and table organisation used.