Re: [sqlite] Efficiency of partial indexes

2018-07-29 Thread D Burgess
On the systems I use, for log files, you cant beat a text file for integrity and speed. I would suffer the slower queries and use something like the CSV extension on your text log files. On Mon, Jul 30, 2018 at 10:44 AM, Simon Slavin wrote: > I have a particular logging task which is time-critic

[sqlite] Efficiency of partial indexes

2018-07-29 Thread Simon Slavin
I have a particular logging task which is time-critical, both in reading and writing. It runs on Linux, but not a fast desktop computer, more like the slow kind built into your WiFi router, with limited solid state storage. I can use any version of the SQLite C API I want, and currently use a