Dobject build slow all of a sudden

Issue description

Since a couple of days the dobject build is significantly slower. It takes now 9 seconds to build 500 dobjects where it took only hald a second before. Figure out why that is. Keep in mind that the OS was upgraded including MySQL.

Developer comments

This is has nothing to do with MySQL. For some reason there is now many more dobjects built newly instead of just synced. The goal is to build the dobjects for new topics only and sync old ones with the changes made in memory. But this is no longer the case.

This was caused by some refactoring and is a more severe issue than it seems. It essential for the working of Topincs that the syncing of the secondary dobject represenation is fast, otherwise overlapping POST service executions get in each others way causing unnecessary exception. In particular the request fails since the lock for syncing cannot be performed within two seconds. It works now, but remains unclear how to improve the code regarding the managing of the three states MySQL, tobjects (memory) and dobjects (filesystem) and in particular the transaction handling. All the relevant "hot" code locations are quite scattered.

Reporting date

2024-09-04

Reported by

Robert Cerny

Resolving date

2024-09-09

Resolved by

Robert Cerny

Resolved in version

Topincs 10.0.0 - next major release

Caused by

Rollback after a package save might cause dobject divergence(Bug)

Work sessions2

Start	2024-09-05T09:00:58
End	2024-09-05T11:26:32
Participant	Robert Cerny

Start	2024-09-05T14:09:12
End	2024-09-05T17:48:06
Participant	Robert Cerny