Sparx Systems Forum
Enterprise Architect => Bugs and Issues => Topic started by: antoineatstariongroup on September 25, 2024, 06:41:59 pm
-
Hi !
I'm currently working on an Enteprise Architect model in SysML. The model is hosted into a VM (with PostgresSQL database) and can be accessed via the native connection.
Any update on the model is going smoothly, except the addition of information item when I can to put some 'Information Flows Realized' for some message on a Sequence Diagram.
When doing it, I notice a huge slows down of the system, where the pop-up dialog freezes and it really takes some time to be available again.
I'm facing this slow-down with the version 17.0 but also noticed it in previous version. Is it a specific thing that could be done on the server to resolve this issue ? (Doing the manipulation on a standard QEA file is completly fine).
Thanks !
-
There are a few things you can try:
- Use Pro Cloud Server to connect instead of native connection
- Move the client closer to the database (and use Remote Desktop/Citrix to use it)
- Investigate on database level why this is taking so long. Sometimes adding an index can help a lot. In that case I would report the bug (and the solution) to Sparx so they can included it in the standard database DDL for PostgresSQL
Geert
-
Thanks Geert for you reply !
I tried to inspect logs related to insertion of those "Information Flows Realized" information, and it looks that the SQL statement is rather big and may be improved. As far as I could check, it seams that requested data are already correctly indexed.
Would you like that I share collected logs?
I also noticed that sometimes, that request is quite ok in terms of perfomance, sometimes not... Locally (with a standard QEA file), it could also be sometimes slower.
-
Would you like that I share collected logs?
Not necesarrily here, but I would send a bug report to Saprx with all dat info.
Hopefully they can either improve the query, or the database schema.
Geert