I do a test with Valentina Server for SQLITE (licence 5 connexions) and Xojo.
It's a Web app.
With a session, I run an import of one million lines.
During this import, another session tries to import a single line.
Of course, the second can not be imported because the engine is already locked on the first writing.
BUT it seems that the server does not respecte the timeout. This timeout is 10 seconds. Usually SQLITE refuses writing at the end of this timeout. With valentina server, the writing is rejected immediately, without waiting for the timeout.
I forgot something ?
Here the project:
- Launch the project
- Run a session in a web browser (http: //127.0.0: 9000)
- Open another session on a web browser (http: //127.0.0: 9000)
- On the first session, click "insert". The import starts and will take several minutes.
- Meanwhile, on the second session,click "go page2" then "Insert 1 line". Writing is denied immediately without waiting for the timeout.
I did the test on Windows 10, Xojo 2015R4. I downloaded the latest version of Valentina Server yesterday. You can view the logs in the Windows event viewer.