On Thursday 11 June 2009 14:54:04 Igor Tandetnik wrote: > Because this query is no longer a simple select. It is translated > internally into > > select min(C) from > (SELECT * FROM T WHERE (C=1 OR C=2));
Ah, this would indeed explain the slowdown. I was hoping views would translate into the "where" part of the query, like: SELECT min(C) FROM T_view; -> SELECT min(C) FROM T WHERE (C=1 OR C=2); I may need to find out another way to filter the rows from users. -- Antti Nietosvaara Turun Turvatekniikka Oy _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users