* Philip Martin: >> I suppose I will have to try using EXPLAIN.
As expected, the slow query doesn't use the index. I think you should bring this up on SQLite user mailing list. -- 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