Re: [sqlite] fsync on -wal still happening

>Naturally, and of course. The point of my initial post was that I was >still seeing sync operations with synch=NORMAL when I shouldn't have >according to the below docs (now debatable whether they were actually >written to disk or just the os cache). I purposely configured synch >to >NORMAL to

Re: [sqlite] fsync on -wal still happening

On 30 Dec 2017, at 4:38pm, Ian Freeman wrote: > Naturally, and of course. The point of my initial post was that I was still > seeing sync operations with synch=NORMAL when I shouldn't have according to > the below docs (now debatable whether they were actually written to

Re: [sqlite] fsync on -wal still happening

On 30.12.2017 01:14, Keith Medcalf wrote: One presumes that you mayhaps read the documentation? "In WAL mode when synchronous is NORMAL (1), the WAL file is synchronized before each checkpoint and the database file is synchronized after each completed checkpoint and the WAL file header is

Re: [sqlite] PRAGMA help

On Sat, Dec 30, 2017 at 1:04 AM, Tony Papadimitriou wrote: > Is there some way to get a list of all available pragma options from the > SQLite3 shell? > https://sqlite.org/pragma.html If it was built with SQLITE_INTROSPECTION_PRAGMAS, which by default it is not. and

Re: [sqlite] Knowing when not to use a R-Tree index, and clustering tables along spatial indexes

Andrea Aime wrote: > So I was wondering, is there any opportunity to run a blazing fast pre-query > against > the index that will tell me whether joining/subquerying into the rtree is > going to be a win, or not? Each node in an R-tree index stores the coordinates of the leaf objects/child

[sqlite] PRAGMA help

Is there some way to get a list of all available pragma options from the SQLite3 shell? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users