[sqlite] FTS3 segfaults and performance problems in the SQLite 3.6.22

[Alexey Pechnikov]

Hello!

1. The first query is 10x slower! But the performance may be very similar in 
theory:
===========
sqlite> select snippet(file_text) from file_text where rowid=9737 and file_text 
match 'london';
...
CPU Time: user 0.156010 sys 0.016001

sqlite> select length(content) from file_text where rowid=9737 and file_text 
match 'london';
1189837
CPU Time: user 0.016001 sys 0.008001
===========

2. The query below may use only index information but is very slow too:
===========
sqlite> select offsets(file_text) from file_text where rowid=9737 and file_text 
match 'london';
0 0 985905 6 0 0 1154740 6 0 0 1663053 6
CPU Time: user 0.152010 sys 0.008000
===========

3. The offsets() and snippet() functions have no some of the needed checks:
===========
sqlite> select offsets(file_text) from file_text where rowid=9737;
Segmentation fault

sqlite> select snippet(file_text) from file_text where rowid=9737;
Segmentation fault
===========

Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users