Hi, I'm noticing a strange behaviour with SELECT statements.
Let's consider this statement : SELECT * FROM log WHERE id_clie...@idclient ORDER BY utc DESC LIMIT 1 The table has an index on the "utc" and "id_client" fields pair. When running this query with an @IdClient value which exists in the table, the query returns instantly (< 200ms) When running this query with an @IdClient value which doesn't exist in the table, the query is slow (2,63s) When running this query with an @IdClient value which exists in the table and the "NOT INDEXED" keywords, the query is slow too (2,84s) It seems to me the DB engine tries to perform an unindexed search if the requested value is not present in the index. Is this behaviour intended ? How can I get rid of it ? Regards, -- Grégoire de Turckheim - TAVEO Gérant - www.taveo.com Mob: 06 26 92 40 02 - Tel: 09 50 58 40 02 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
