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
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
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
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
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
>
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
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
7 matches
Mail list logo