skywind mailing lists wrote:
> this is a slow query for FTS tables:
>
> SELECT * FROM mail WHERE rowid BETWEEN 15 AND 20;
>
> As far as I know both queries are fast on normal tables. Where is the 
> difference / what is the reason for the performance difference?

Virtual table modules must implement every lookup type that needs to be fast.
The FTS module does not implement rowid lookups with inequalities.


Regards,
Clemens

Reply via email to