I red this article on wiki:
http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
I've got a similar case but the difference is that I've to use LIKE
operator instead of =
SELECT title FROM tracks
WHERE title LIKE %Mad% AND ((title=:last_title AND id>:last_id)
OR ((title>:last_title)) ORDER BY title,id;
id is the primary key and I created an index for (id,title).
My question is: will the previous query be actually faster then just
only using OFFSET and LIMITS even if I also need a LIKE operator on
title column?
Thanks.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
