Enhancement
Improve factsheet for association rich topics
Issue description
When a topic contains a lot of associations, the fact sheet loads slow. In many cases the user is not interested in all the associations.
Developer comments
The slow reaction time was caused, as expected, by too many individual SQL statements. There were three separate underlying issues.
* The assembly of the associations was asking individually for scope, label and counter player. This was refactored so that a single SQL statements suffices for all associations.
* The topic proxy cache prefilling was not correct. It used isset instead of array\_key\_exists. This caused the ones without a subject locator to be requeried from the database.
* Thirdly and this was the most surprising. When an association axis was omitted to speed up loading, it had the negative effect of slowing it down. Because in the absence of the respective constraint the name for the parapgraph would be requeried for every statement from the database, despite it not even being displayed.
With all the changes in place, a factsheet that used to load in 34 seconds now loads in 2 seconds.
Even in extra large pages the bottleneck is no longer the server, but the client.
|
Work sessions
Start |
2023-04-03T13:08:04
|
End |
2023-04-03T17:26:55
|
Participant |
Robert Cerny
|
|
We are sorry
This page cannot be displayed in your browser. Use Firefox, Opera, Safari, or Chrome instead.