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

Reply via email to