Dears FTS3 performance is acceptable for SQLite 3.6.20 when the FTS virtual table contains 10K~100K records. (Query speed: 20K records/ 0.4831sec) but the performance is bad for SQLite 3.6.21~3.6.23.1 (Query speed: 20K records/ > 7sec)
The query is simple: *SELECT docid FROM XTable WHERE XTable MATCH '0*'* *CREATE VIRTUAL TABLE XTable USING fts3(Name TEXT NOT NULL, URL TEXT NOT NULL, Date TEXT NOT NULL, Links TEXT );* * * -- Best Regards, James S. Hsieh http://design-studio.lookin.at/ http://picasaweb.google.com/NomadLibra _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users