Hello all
If I look at the "Locking And Concurrency"-Description from my
current Viewpoint, as a Viewpoint with present understandig, the
Description is ok.
If I remember to my Viewpoint in the past, without this present
understandig, before some very pleasant helppostings explain the
[EMAIL PROTECTED] wrote:
Original-Nachricht
Datum: Wed, 05 Jul 2006 17:24:54 -0500
Von: John Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hello John
Ann don't cry into your beer, there is always next time! My team als
Original-Nachricht
Datum: Wed, 05 Jul 2006 17:24:54 -0500
Von: John Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hello John
> Ann don't cry into your beer, there is always next time! My team also
> got knocked
nto German).
[EMAIL PROTECTED] wrote:
Original-Nachricht
Datum: Wed, 05 Jul 2006 13:01:12 -0500
Von: John Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
First, sad about the football, but someone has to win.
Its only footbal
Original-Nachricht
Datum: Wed, 05 Jul 2006 19:30:04 +0100
Von: Nikki Locke <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
> We seem to have a misunderstanding over the definition of "optomistic
> locking".
Yes,
Original-Nachricht
Datum: Wed, 05 Jul 2006 13:01:12 -0500
Von: John Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
> First, sad about the football, but someone has to win.
Its only football... and so hard it is... th
-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hi John
I think, I understand what you will to say
Sqlite is a single file shared between users just like a word processing
file shared between multiple users. It is not a DBMS server and just
uses the regular fcntl type file locks.
bu
Original-Nachricht
Datum: Wed, 05 Jul 2006 07:32:47 -0600
Von: Dennis Cote <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
> Anne,
>
> Yes, ...
A simple "Yes" :-)))
>...your description is correct
Hi D
-Nachricht
Datum: Wed, 05 Jul 2006 12:05:07 +0100
Von: Nikki Locke <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
> ...the way SQLite works during a database update is that the
> entire database file is locked, and remains locked unti
[EMAIL PROTECTED] wrote:
but... I want try to ask again... ;-)
SQLite handles the File-Lockings as a physical Locking during the
writings to File and Disk. (Is it so?) I do my own logical Locking
during the Edit of a Record and then reflect to the Busy-State if the
changes will be saved to
Original-Nachricht
Datum: Wed, 5 Jul 2006 13:19:30 +0200
Von: "Olaf Beckman Lapré" <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hi Olaf
> Why not use optimistic locking (timestamp based pseudo locking)? It's
> ussua
Why not use optimistic locking (timestamp based pseudo locking)? It's
ussually sufficient.
Olaf
- Original Message -
From: "Nikki Locke" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Wednesday, July 05, 2006 1:05 PM
Subject: Re: [sqlite] Multipl
> 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?
As I understand it
Original-Nachricht
Datum: Tue, 04 Jul 2006 19:13:56 -0500
Von: John Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hi John
I think, I understand what you will to say
> Sqlite is a single file shared between users
Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hello Gerrry, Aristotle and John
Many thanks for your answers. I'm very glad about your help.
Yes, I found this Page (File Locking And Concurrency In SQLite
Version 3) at last weekend and read i
Original-Nachricht
Datum: Tue, 04 Jul 2006 12:01:25 -0500
Von: John Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hello Gerrry, Aristotle and John
Many thanks for your answers. I'm very glad about your help.
Yes, I
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
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [2006-07-03 21:35]:
> 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.
That’s because
[EMAIL PROTECTED] wrote:
Hi to all
... any questions... ;-)
How many Users can operate with one SQLite-DB at the same time?
Anne,
Look at the following documentation, and if you have further questions,
do not hesitate to ask:
http://sqlite.org/lockingv3.html
Gerry
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
20 matches
Mail list logo
