Dear Valentina Community
I know, this is not the right place to ask this question, but this Forum is my last hope.
We’re using a software called Dental Lab XP by a Swiss company named “YSD inc.”. The Software uses Valentina-DB as a database solution and we’ve been experiencing the same issues for a while:
- When multiple users work with the software and any of the connected clients runs a function that reads or writes anything from or to the DB, there is a small freeze for about 5-10 seconds. This freeze is not just happening on the client that executed the function, but on all clients currently running the software within the network.
- The software developer has stated that this behaviour is impossible and has never been heard of.
- The small freezes get longer and longer as more clients connect. This can be mitigated by manually restarting the valentina-service on the windows 2012 R2 server every once in a while (the reason this works is why I'm trying to find help in this forum).
- Recently, we’ve connected an external PC to our domain. If this client now executes the same function in Dental Lab XP that reads or writes any data to valentina-DB, his waiting time remotely is about 4 minutes - the entire PC is locked up during the execution of the query - but in this remote case, our internal clients don't lock up.
The database itself is 1.5GB in size, according to the dev, this is tiny and not an issue.
It contains 17 Tables with a total of 1'049'829 entries. The largest table has 725'148 entries.
The Valentina Server Version distributed with the most recent update is a version from 2013.
Has anyone every heard of behaviour like this in regards to valentina-db?
And does anyone know, if updating the Valentina Server to a more recent version could help with this?
I'm really sorry to bother you with this.