On Sunday, January 12, 2020, Roman Fleysher
wrote:
>
> I use SQLite over GPFS , but in DELETE (which I think is the default)
> mode. Not WAL mode. No issues with locking, except performance when
> accessing concurrently from multiple nodes. As others pointed out, this has
> to do with the overhea
network
access with replication. I have not tried it and do not know what is involved.
Roman
From: sqlite-users on behalf of
Richard Hipp
Sent: Saturday, January 11, 2020 8:59 PM
To: SQLite mailing list
Subject: Re: [sqlite] Test failures on GPFS
CAUTION
On 1/11/20, J. King wrote:
>
> WAL mode does not work over the network, so the test failures are presumably
> to be expected.
>
WAL mode should work on a network filesystem, as long as all of the
clients are on the same host computer, and as long as mmap()-ing the
*-shm file gives all the clients
On January 11, 2020 5:57:31 p.m. EST, T J wrote:
>I was interested in using sqlite over GPFS. I've seen a few useful
>threads
>on this:
>
> [...]
>
>Overall, it looks pretty good, but there were some WAL
>failures.
>Could someone comment on the precise implication of those test
>failures?
WAL m
> On Jan 11, 2020, at 2:58 PM, T J wrote:
>
> I was interested in using sqlite over GPFS.
The standard advice on using SQLite over a network file system is “don’t do
it.” Even if you find the rare file system that handles locks properly, you’ll
likely have performance issues.
A client/server
Hi,
I was interested in using sqlite over GPFS. I've seen a few useful threads
on this:
- Network file system that support sqlite3 well
https://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/msg117085.html
- disable file locking mechanism over the network
https://www.
6 matches
Mail list logo