I figured it was something like that, just didn't know the specifics. It all
makes
sense now.
Thanks so much!
- Jeff
- Original Message
From: Jeff <[EMAIL PROTECTED]>
To: modperl@perl.apache.org
Sent: Tuesday, June 19, 2007 12:51:08 AM
Subject: Re: SQLite and multiple proce
Jeff,
Apologies - missed the start of this thread... but reading between the
lines, you are seeing stale data from some DB handles, and updated data
elsewhere? I get the impression that you are replacing / updating the
underlying db files from source control?
>> It's almost like the OS is ke
On 6/18/07, Jeff Nokes <[EMAIL PROTECTED]> wrote:
[Jeff] When I'm testing against my dev server, I'm the only one playing in
that sandbox,
so I'm just doing single requests, there is definitely no locking or
concurrency issues
happening.
I was mostly thinking of the kind of issues that more
- Original Message
From: Nikolay Ananiev <[EMAIL PROTECTED]>
To: modperl@perl.apache.org
Sent: Monday, June 18, 2007 12:27:56 AM
Subject: Re: SQLite and multiple process behavior
>What happens if you pass the AutoCommit => 1 option to DBI's connect method?
I have
Thanks for replying Perrin, see my replies inline below.
- Jeff
- Original Message
From: Perrin Harkins <[EMAIL PROTECTED]>
To: Jeff Nokes <[EMAIL PROTECTED]>
Cc: modperl@perl.apache.org
Sent: Friday, June 15, 2007 7:26:09 PM
Subject: Re: SQLite and multiple process behavior
What happens if you pass the AutoCommit => 1 option to DBI's connect method?
"Jeff Nokes" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I sent this to the SQLite mailing list on June 4th, but never received any
>replies.
> I figure either I'm making a totally rookie mistake somew
On 6/15/07, Jeff Nokes <[EMAIL PROTECTED]> wrote:
(Q1) First, why would what seems to be identical multi-process interaction
with the
DB file achieve different results when attempting to view the updated record?
I see two possibilities. One is that you have a SELECT running in one
process wh
I sent this to the SQLite mailing list on June 4th, but never received any
replies.
I figure either I'm making a totally rookie mistake somewhere, or folks really
don't
know how to help me with this. I'm hoping someone may have some insight to
offer
on this forum. As always, I appreciate any a