Closed cldellow closed 1 year ago
https://github.com/simonw/datasette/blob/0b4a28691468b5c758df74fa1d72a823813c96bf/datasette/filters.py#L313-L324 does json_each to test array membership.
json_each
This is, of course, the right way to do it.
...but probably we would get by just fine if we did column like '%"string-value"%, which seems to be 3x faster:
column like '%"string-value"%
json_each query
yolo everything is a string query
https://github.com/simonw/datasette/blob/0b4a28691468b5c758df74fa1d72a823813c96bf/datasette/filters.py#L313-L324 does
json_each
to test array membership.This is, of course, the right way to do it.
...but probably we would get by just fine if we did
column like '%"string-value"%
, which seems to be 3x faster:json_each query
yolo everything is a string query