Medcalf [kmedc...@dessus.com]
Sent: Saturday, September 28, 2019 12:48 AM
To: SQLite mailing list
Subject: Re: [sqlite] disable file locking mechanism over the network
On Friday, 27 September, 2019 22:11, Roman Fleysher
wrote:
>Based on the link you provide, it looks like I need unix-none
On Sat, 28 Sep 2019 at 06:59, Roman Fleysher
wrote:
> ( somewhat related to Re: [sqlite] Safe to use SQLite over a sketchy
> network?)
>
> Dear SQLiters,
>
> I am using SQLite over GPFS distributed file system. I was told it
> honestly implements file locking. I never experienced corruption. But
On Friday, 27 September, 2019 22:11, Roman Fleysher
wrote:
>Based on the link you provide, it looks like I need unix-none VFS and
>specify it as:
>ATTACH 'file:demo2.db?vfs=unix-none' AS demo2;
Yup. I think you can also do that when opening the file on the sqlite3_open_v2
call by using the
, 2019 11:50 PM
To: SQLite mailing list
Subject: Re: [sqlite] disable file locking mechanism over the network
Yeah, WAL mode cannot work over a remote connection as the WAL index is a
shared memory file -- which can only be accessed by processes on a single
computer.
If you are using FLoM to co
: Friday, 27 September, 2019 21:49
>To: SQLite mailing list
>Subject: Re: [sqlite] disable file locking mechanism over the network
>
>I agree that overhead might grow exponentially with number of nodes
>trying to access the database. But then I do not understand why FLoM can
>not pr
Subject: Re: [sqlite] disable file locking mechanism over the network
On Friday, 27 September, 2019 17:00, Roman Fleysher wrote:
>I am using SQLite over GPFS distributed file system. I was told it
>honestly implements file locking. I never experienced corruption. But it
>is slow in the sense
rs [sqlite-users-boun...@mailinglists.sqlite.org] on
>behalf of Simon Slavin [slav...@bigfraud.org]
>Sent: Friday, September 27, 2019 7:53 PM
>To: SQLite mailing list
>Subject: Re: [sqlite] disable file locking mechanism over the network
>
>On 27 Sep 2019, at 11:59pm, Roman Fleysher
>
27, 2019 7:53 PM
To: SQLite mailing list
Subject: Re: [sqlite] disable file locking mechanism over the network
On 27 Sep 2019, at 11:59pm, Roman Fleysher
wrote:
> From experience, it seems that because SQLite still requests file locks, the
> performance increase is not that big. I
On Friday, 27 September, 2019 17:00, Roman Fleysher wrote:
>I am using SQLite over GPFS distributed file system. I was told it
>honestly implements file locking. I never experienced corruption. But it
>is slow in the sense that when many jobs from many compute nodes try to
>access the same
On 27 Sep 2019, at 11:59pm, Roman Fleysher
wrote:
> From experience, it seems that because SQLite still requests file locks, the
> performance increase is not that big. I wonder if there is a way to disable
> SQLite's internal file locking mechanism. I know this seems strange to ask.
> But
( somewhat related to Re: [sqlite] Safe to use SQLite over a sketchy network?)
Dear SQLiters,
I am using SQLite over GPFS distributed file system. I was told it honestly
implements file locking. I never experienced corruption. But it is slow in the
sense that when many jobs from many compute
11 matches
Mail list logo