* Philip Martin: > We have started using queries of the form > > SELECT ... WHERE ... AND local_relpath LIKE ... > > and I was curious about the performance of LIKE.
LIKE is ASCII-case-insensitive in SQLite, and the indexes are case-sensitive by default, so SQLite can't do the usual range optimization. You could try pragma case_sensitive_like, or try switching to the GLOB operator. -- Florian Weimer <fwei...@bfk.de> BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99
