Re: [sqlite] Prebuilt Windows x86 binary missing symbols per sqlite3.def

2017-06-03 20:22 GMT+02:00 Acer Yang: > Sqlite version is 3190220. > x86 and x64 prebuilt Windows binaries are downloaded from > https://www.sqlite.org/download.html > > I compared sqlite3.def files with sort and diff tools. > Some missing symbols as of x86 def file are listed below. > >

[sqlite] [PATCH] fix (a little bit more of) `.mode column` with utf-8

yum...@gmail.com (Yuriy M. Kaminskiy) writes: > However, not everywhere; this code auto-detects column width: > if( w==0 ){ > w = strlen30(azCol[i] ? azCol[i] : ""); > if( w<10 ) w = 10; > n = strlen30(azArg && azArg[i] ? azArg[i] : p->nullValue); >

Re: [sqlite] Importing from single-insert-statement SQL dump is 61 times slower than importing from SQL dump with one statement per row

Clemens Ladisch writes: > Sarge Borsch wrote: >> time xzdec something.sql.xz | sqlite3 something.db > > This measures only xzdec; it does not catch anything that sqlite3 does > after xzdec has finished and closed the pipe. Nitpick: In bash or zsh, `time` is handled by shell,

Re: [sqlite] WAL checkpoint starved?

Den 2017-06-02 kl. 16:07, skrev Richard Hipp: On 6/2/17, Daniel Polski wrote: I've found something weird in a log from a client. Normally our WAL files are < 100kB, but in this log I noticed the file was >40MB. This was totally unexpected since we run this call every

Re: [sqlite] WAL checkpoint starved?

Den 2017-06-02 kl. 16:07, skrev Clemens Ladisch: Daniel Polski wrote: Any ideas why I can end up with that large WAL file Sounds like checkpoint starvation. Does the checkpoint call actually succeed? Unfortunately I don't know (adding a log message for that now). Any suggestions about how