Has somebody got amnesia or something? I think I've seen this question
going on four or five times now.
> -Original Message-
> From: Dave Dyer [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 03, 2005 12:40 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] basic question about
Edward Wilson said:
> What is the best approach to concurrency in this scenario?
>
Don't choke when you get a SQLITE_BUSY error. Just wait and try again in
a second or so.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
What is the best approach to concurrency in this scenario?
--- Clay Dowling <[EMAIL PROTECTED]> wrote:
>
> Dave Dyer said:
> >
> > If I designed a sqlite database to be used by a bunch of independent
> > applications, for example a bunch of CGI scripts each of which
> > opened the database, did
Dave Dyer said:
>
> If I designed a sqlite database to be used by a bunch of independent
> applications, for example a bunch of CGI scripts each of which
> opened the database, did some processing, and exited, would
> that be (a) safe (b) effecient ?
It's very safe. My own product does that
Yes to both questions. Just make sure that your application can handle
the situation of occasionally finding the database locked momentarily.
In our tests on an old 200MHz server such a CGI process executes in 10mS
or less and would permit maybe as many as 200 simultaneous users.
JS
Dave Dyer
> If I designed a sqlite database to be used by a bunch of independent
> applications, for example a bunch of CGI scripts each of which
> opened the database, did some processing, and exited, would
> that be (a) safe (b) effecient ?
I think lots of people have used that pattern successfully.
It would be safe and efficient provided that you did not have a massive
load with many processes expecting simultaneous access. Just be careful
that your applications can gracefully handle the occasional lock state
and use transactions carefully. Don't design in queries which have a
long
On 10/28/05, Dave Dyer <[EMAIL PROTECTED]> wrote:
>
> If I designed a sqlite database to be used by a bunch of independent
> applications, for example a bunch of CGI scripts each of which
> opened the database, did some processing, and exited, would
> that be (a) safe (b) effecient ?
As long as
8 matches
Mail list logo