On Nov 13, 2019, at 11:31 AM, Simon Slavin <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
