Hello! The 'OR' queries is really fast, is it possible to speed-up a multi-terms union search (AND) queries? The "optimize" of the fts table does not resolve the problem.
1. Fast queries: sqlite> select * from data where data match 'AF8FD58037AFD629F13518658B94CD2C'; 0|0|zero|AF8FD58037AFD629F13518658B94CD2C CPU Time: user 0.000000 sys 0.000000 sqlite> select * from data where data match '66D0C590E736A15AA74FFC6CA838EA9B OR AF8FD58037AFD629F13518658B94CD2C'; 0|0|zero|66D0C590E736A15AA74FFC6CA838EA9B 0|0|zero|AF8FD58037AFD629F13518658B94CD2C CPU Time: user 0.000000 sys 0.000000 sqlite> select count(*) from data where data match '66D0C5* OR AF8FD5*'; 18 CPU Time: user 0.004000 sys 0.000000 1. Slow queries: sqlite> select * from data where data match 'zero AF8FD58037AFD629F13518658B94CD2C'; 0|0|zero|AF8FD58037AFD629F13518658B94CD2C CPU Time: user 2.540159 sys 0.152010 sqlite> select * from data where data match 'zero AND AF8FD58037AFD629F13518658B94CD2C'; 0|0|zero|AF8FD58037AFD629F13518658B94CD2C CPU Time: user 2.456154 sys 0.156009 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
