On 9/21/2011 12:19 PM, Paul Sanderson wrote:
Thanks Igor
That makes sense but if I drop MD5 from the query (the vast majority
of MD5 values would be null anyway) and use
select ID FROM rtable WHERE search> 0 and isf = 0 ORDER BY afo
The result from explain query plan is
0|0|0 SCAN TABLE rtable (~33333 rows)
0|0|0 USE TEMP B-TREE FOR ORDER BY
Which seems to indicate that the b-tree is still being created (I'll
test shortly, but running another long test at the moment)
Double-check that you indeed have an index on afo. Show the output of
this statement:
select * from sqlite_master where tbl_name='rtable';
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users