Slow sqlite insertion

[listyque]

Describe the bug
Query from sqlite db takes no time, but when something needs to be updated or inserted - tactic freezes

To Reproduce
Steps to reproduce the behavior:

1. Install TACTIC Team 4.8 py3
2. Insert any sobject, checkin, tasks etc
3. See time for insertion or updating takes longer than in could be in other bd's

Expected behavior
Faster db inserction

[remkonoteboom]

I did a bit of testing on this and the performance seems to be very fast, even on insertion and updating. However, this is SQLite, and one thing SQLite is very very bad at is concurrency. Is it possible that there is other process holding up the table?

[listyque]

All logs showing pretty much fast transactions, but there is "freezing" between the transactions.
How to check if this might be related to concurrency?

[remkonoteboom]

I don't know a lot about SQLite. I just know that when people have tried to use SQLite with multiple users, it tends to lock up. On your other issue:

#1571

you even have get a database is locked error. However, it seems likely that the database locks for some period of time and releases the lock and other transactions can proceed.

It is possible that under certain conditions, there are multiple requests going to the server backend and locking up the database somehow. The dynamic update of widgets are requests that are happening in the background as well as some messaging. I wonder if these are causing the database to lock up.

[listyque]

Then it looks like a really big problem.
May be there should be portable postgresql to replace sqlite in tactic team