Bug
Large system: slow range retrieval
Issue description
In a large system the range retrieval is slow despite (1.4s on average) while being only for a single select box.
Developer comments
See table column in vcargo.
The response time of the range request behaves in three different ways. All assuming that the response is built fresh and not served from the Topincs response cache.
*very long* – first request after a domain edit: 1.300 ms, 20 sql, 223 MB Ram
*long* – second request after a domain edit: 600 ms, 19 sql, 389 MB Ram
*short* – third and later request after domain edit: 13 ms, 19sql, 1 MB
The main problem here is the frozen topics table. The difference between *very long* and *long* is a single SQL statement, which loads the complete frozen topics table. In the system at hand it has almost 2 Mio topics. 90% of all topics are frozen. This is done no matter what, if the whole range spans 3 topics or 50000.
It is even loaded if the range count is 0!
Response times of range before changes, average of 5 work days:
* cargo: 0.79 seconds
* medien: 0.41 seconds
The range retrieval has n tuples of these parameters:
* 1 × axis (rt/at/ort)
* n × counter player topic type with maximum cardiniality mostly 1 or *
* 1 × Most likely
* 0 or 1 × search string
* 0 or 1 × meta
One day after first change (refactor frozen topics):
* cargo: 0.21 seconds
* medien: 0.81 seconds
With all changes 1 day in production:
* cargo: 0.14 seconds
* medien: 0.34 seconds
|
Work sessions9
Start |
2024-02-15T09:03:16
|
End |
2024-02-15T10:36:09
|
Participant |
Robert Cerny
|
Start |
2024-02-15T15:07:34
|
End |
2024-02-15T17:09:59
|
Participant |
Robert Cerny
|
Start |
2024-02-16T09:02:25
|
End |
2024-02-16T12:00:20
|
Participant |
Robert Cerny
|
Start |
2024-02-16T12:30:20
|
End |
2024-02-16T14:11:22
|
Participant |
Robert Cerny
|
Start |
2024-02-16T14:53:18
|
End |
2024-02-16T18:07:38
|
Participant |
Robert Cerny
|
Start |
2024-02-17T11:58:41
|
End |
2024-02-17T12:35:52
|
Participant |
Robert Cerny
|
Start |
2024-02-18T09:18:03
|
End |
2024-02-18T10:11:54
|
Participant |
Robert Cerny
|
Start |
2024-02-18T10:33:19
|
End |
2024-02-18T11:31:53
|
Participant |
Robert Cerny
|
Start |
2024-02-19T07:47:16
|
End |
2024-02-19T09:00:22
|
Participant |
Robert Cerny
|
|
We are sorry
This page cannot be displayed in your browser. Use Firefox, Opera, Safari, or Chrome instead.