2011/10/12 Dan Kennedy <danielk1...@gmail.com>
> > Are you using 3.7.7 or newer? And specifying the order=DESC > option when creating the FTS4 table? If not, it might be a big > help in this case. > > > http://www.sqlite.org/fts3.**html#fts4order<http://www.sqlite.org/fts3.html#fts4order> > > Yes I'm using 3.7.7, and I already considered specifying order=DESC upon creation, but I suspect it will reverse the problem: Slow queries with OFFSET=0 and fast queries with a large OFFSET, which would be no solution. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users