Information Flows Realized: Adding information item super slow

[antoineatstariongroup]

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 !

[Geert Bellekens]

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

[antoineatstariongroup]

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.

[Geert Bellekens]

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