This page is not created by, affiliated with, or supported by Slack Technologies, Inc.
2018-11-05
Channels
- # 100-days-of-code (1)
- # announcements (7)
- # beginners (84)
- # boot (1)
- # cider (22)
- # cljdoc (14)
- # cljs-dev (45)
- # cljsrn (6)
- # clojure (65)
- # clojure-conj (7)
- # clojure-finland (1)
- # clojure-italy (7)
- # clojure-nl (2)
- # clojure-serbia (1)
- # clojure-uk (111)
- # clojurescript (58)
- # cursive (8)
- # datomic (68)
- # duct (1)
- # emacs (33)
- # figwheel (3)
- # figwheel-main (9)
- # fulcro (33)
- # graphql (1)
- # juxt (30)
- # kaocha (4)
- # off-topic (22)
- # pathom (47)
- # pedestal (4)
- # planck (6)
- # re-frame (1)
- # reagent (1)
- # reitit (13)
- # shadow-cljs (49)
- # spacemacs (7)
- # sql (6)
- # tools-deps (60)
I'm a little confused about a situation in which SQLite doesn't seem to use existing indexes unless ANALYZE
is ran beforehand: https://gist.github.com/martinklepsch/c5987fdce5a3ad830264e39b22968bca
If anyone has experience with this I'd appreciate your input 🙂
is it only analyze that causes the index to be used? or if you do an insert or something does it cause it to be used?
@martinklepsch It may depend on the version of SQLite you're using. Also, SQLite's like
is case-insensitive by default so it won't use the index unless a) the index is case-insensitive or b) analyze determines that case doesn't matter. I'm guessing at b) based on various SO answers.
See for example https://stackoverflow.com/questions/12994870/sqlite-not-using-index-with-like-query
interesting - I thought I tried without the like clause but your findings make me doubt myself 😀