Bug
Autocommit off: sometimes saving longer than before
Issue description
Processes that took 8 seconds before take 34 seconds now. That was not the plan. Figure out why and improve.
Developer comments
Here is the reason for this unexpected result. The change is that now the modifications through the API are collected and written in as few SQL statements as possible. Before it was done with individual SQL modifications statements. Now in bulk through the FastWriter. The FastWriter checks for value identity of names, occurrences and associations. This check, in particluar one SQL query delays the progress.
|
Work sessions3
Start |
2023-02-25T07:51:25
|
End |
2023-02-25T10:01:37
|
Participant |
Robert Cerny
|
Start |
2023-02-25T10:59:09
|
End |
2023-02-25T12:11:14
|
Participant |
Robert Cerny
|
Start |
2023-02-25T15:25:37
|
End |
2023-02-25T16:26:12
|
Participant |
Robert Cerny
|
|
We are sorry
This page cannot be displayed in your browser. Use Firefox, Opera, Safari, or Chrome instead.