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 -- "Feel free" – 10 GB Mailbox, 100 FreeSMS/Monat ... Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail
