Using SQLite as a multi-user database?

[Ruslan Zasukhin]

On 11/23/10 8:41 PM, "Jonathan Lynch" <jonathandlynch at gmail.com> wrote:

> I am in the same sort of boat.
> 
> I am making an application that would use a database file on a shared drive.
> Maybe 10-20 people would be writing to it during any given day. It seems
> like Valentina would be a good choice for this, but, as silly as it sounds,
> I don't have a practical funding mechanism to pay for the $200 expense.
> 
> I might try doing it with SQLite, but this conversation, and a few previous
> conversations related to this topic, are making me nervous about doing that.

* From 1998 to 2002(3) year ...
While Valentina engine was single user only and was no Valentina Server,
Valentina users did use OPEN/CLOSE trick


I think you can use the same trick now for both
A) SqlLite 
B) Valentina in single user mode

For their dbs that are on shared volume.


I remember that yet in 1999-00, on that time hardware,
Was a German user, which told he is able manage in this way group in 50-100
users.

On modern hardware limits can be higher I think.

-----
And keep in mind that this open/close trick, of course kills idea of DB
Cache.

Another Valentina user did bench, and told us that for him, Valentina Server
way works near to 17-20 times faster of open/close trick.



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]