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