We are continuing to have problems with performance. I have asked the hosting company to investigate. This is their answer:
Thank you for being patient.
We’ve reviewed the database process list, and it appears that multiple queries are waiting for table-level locks on the ubbthreads DB. This is causing temporary delays for some operations. The main reason is that several queries are accessing the same tables simultaneously, leading to contention.
https://hw-screenshots.sea-proxy.wi...77c48b4b-f997-473b-819c-134dc3f38147.png
To fix this issue, we recommend:
Improving your database queries and indexes to make them run faster.
Break large operations into smaller parts to avoid putting too much load on the database.
We appreciate your patience and understanding on this matter.
Feel free to contact us if you have further queries or concerns.
Thank you.
