[sqlite] SQLite I/O tuning redux

2016-02-20 Thread Simon Slavin
On 20 Feb 2016, at 8:48pm, Dave Baggett wrote: > I have covering indices that make some of our common queries run a lot > faster. It turns out that the vast majority of my writing to disk is simply > to maintain these indices. Obviously, I will remove as many indices as I can, > but as it is

[sqlite] SQLite I/O tuning redux

2016-02-20 Thread Dave Baggett
Further to me earlier plea for help -- here's an update and another question. In an attempt to precisely understand exactly why and where we're doing writing, I've added a bit of code to SQLite to measure aggregate disk I/O, along with a profiling hook that lets me measure the amount read and

[sqlite] SQLite I/O tuning redux

2016-02-20 Thread Richard Hipp
On 2/20/16, Dave Baggett wrote: > > Question: can I force SQLite to keep an index purely in memory, No. Because if you did, other processes updating the table would have no way of also updating the index. -- D. Richard Hipp drh at sqlite.org

[sqlite] Process duplicate field values

2016-02-20 Thread ad...@shuling.net
No. Originally I think since task 2 and 3 are operations performed on the same set of records, maybe they can be merged to improved the performance though one is get and another is set. Thank you very much > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org

[sqlite] [BUG on version 3110000] link error: undefined reference to 'explainIndexColumnName'

2016-02-20 Thread Richard Hipp
On 2/19/16, Michele Dionisio wrote: > building version 311 with the following options: > > -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS3 > -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_EXPLAIN_COMMENTS -O2 > -fno-stack-protector -fomit-frame-pointer -DUSE_PREAD >

[sqlite] Simple SQLite app importing from mmssms.db and using GContacts

2016-02-20 Thread Philip Rhoades
People, I periodically crash or otherwise do a factory reset on my Android phone but rather than restoring all the SMS messages I would like to just import from the backup mmssms.db into a Linux app and keep all the old messages for historical posterity allowing me to search and look up

[sqlite] NuGet problem

2016-02-20 Thread da...@andl.org
Can someone tell me where the NuGet package gets built, so I can have a look and see what needs to be done? Regards David M Bennett FACS Andl - A New Database Language - andl.org -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-bounces at