On Nov 13, 2019, at 11:31 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > Don't substring searches help you more than sorted lists ?
There’s a relevant question for this list: how do we do this efficiently? The naive solution involves a table scan. Enable FTS on that column? Manual extraction into indexed lookup tables? Give up on names and use something else? (SSN, phone number, DOB…) Something else? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users