Hi all, I'm happily using snippet generation in FTS3, but I notice that it has a fairly large performance impact (5 seconds or more) on queries that return lots of data (tens of thousands of rows) In my application, I never display more than the first 20 rows returned by the MATCH operator, and I so I never need to do more than 20 snippets at a time.
Based on the performance behavior my guess is that FTS3 does snippets for each matching row, as opposed to finding the rows to return and then doing snippets on that subset. Does anyone know if that is true? Thanks, Tim _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
