Re: [PATCH] Tweak over.sqlite3 queries for sqlite < 3.8

2018-06-18 Thread Eric Wong
Thanks, applied. -- unsubscribe: meta+unsubscr...@public-inbox.org archive: https://public-inbox.org/meta/

[PATCH] Tweak over.sqlite3 queries for sqlite < 3.8

2018-06-18 Thread Konstantin Ryabitsev
The query planner in sqlite3 < 3.8 is not very clever, so when it sees num mentioned in the query filter, it decides not to use the fast idx_ts index and goes for the much slower autoindex. CentOS-7 still has sqlite-3.7, so loading the http landing page of a very large archive (LKML) was taking