Quick question. If I am using FTQ that looks like this "SELECT * FROM mail WHERE body MATCH 'sqlite' " can I add to it "WHERE rowid > 5 AND rwoid <10" or it will significantly slow it down. If so what would be the best approach for pagination, For example if I get 500 rows with the matching term and obviously I do not need them all right away. Should I just use the first option and maybe select only rowids and then go through them?
Any suggestions? Thanks -- View this message in context: http://sqlite.1065341.n5.nabble.com/FTS-pagination-tp78754.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users