Re: SQLite and SELECT WHERE local_relpath LIKE

From: Florian Weimer <fweimer_at_bfk.de>
Date: Fri, 29 Oct 2010 08:43:59 +0000

* 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                <fweimer_at_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

Received on 2010-10-29 10:44:36 CEST

This message: [ Message body ]
Next message: Noorul Islam K M: "Issue 3727 - svn export into the current directory"
Previous message: Philip Martin: "SQLite and SELECT WHERE local_relpath LIKE"
In reply to: Philip Martin: "SQLite and SELECT WHERE local_relpath LIKE"
Next in thread: Philip Martin: "Re: SQLite and SELECT WHERE local_relpath LIKE"
Reply: Philip Martin: "Re: SQLite and SELECT WHERE local_relpath LIKE"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ] [ by messages with attachments ]