If your application observes the locking rules or provides its own synchronization you can have very many concurrent users. If your application doesn't observe locking you can only have one user.

Your question is the same as "how many users can share a file", because Sqlite is basically a file.

To implement your locking strategy you might find that you need to have multiple Sqlite databases so that you can lock individual sets of tables using the Sqlite file locks.

If you need elaborate table locking you might find that you lose the simplicity of Sqlite and might find a DB like PostgreSQL more appropriate.

Good luck to Germany in the FIFA Cup.

[EMAIL PROTECTED] wrote:
Hi to all

... any questions... ;-)

How many Users can operate with one SQLite-DB at the same time? That means (for example) max 5 users can work with a MDB (MS Access)
connected via OLEDB. If more then 5 Users (writer) connect, the MDB
getting often instable or corrupt. Is the a recommended limit to SQLite?

In order to this, the next question ;-) Is a physcial Locking to the DB allways necessary, if more the one User (writer) connect to a DB and a Table? That means, is it insufficient, if I handle only a logical Locking in the Application instead of physcial Locking?
In my App it is necessary, to lock a group of appended Records from
multiple tables, if a user will edit a specific Record in one of any table. The User opens (for example) a Record from a staff member, to edit personal data. At this time all appended Records in other tables of this staff member must be also locked. I perform that with a logical locking in combination with a DB-Connect-Parameter "Optimistic Locking".

Pessimistic Locking from the client program means that holding the lock for the entire duration of the view/edit/update of the record. The opposite of this is called "optimistic locking", in which hold a lock on the record for only as long as it takes for the database engine to physically update the row. To avoid a conflict to the personal data I do my logical locking. A physically conflict avoid the DB.

How many Users can be reader/writer to a DB at the same time, if all User controlled by the logical Locking-System? I have searched in Mail-Archiv and in Docu, but I dont found any Infos about concurrent Users.

Many thanks and best greetings from Germany
Anne

Reply via email to