sqlite> .schema role CREATE VIRTUAL TABLE role USING fts3(uuid TEXT, uid INTEGER, dt TEXT, ts INTEGER, fields, tasks, TOKENIZE icu ru_RU);
Fast queries: sqlite> select count(*) from role where role match '1278429059'; count(*) 471 CPU Time: user 0.000000 sys 0.000000 sqlite> select count(*) from role where role match '19 10 59'; count(*) 476 CPU Time: user 0.584037 sys 0.000000 Slow queries: sqlite> select count(*) from role where role match '"19:10:59"'; count(*) 471 CPU Time: user 3.500219 sys 0.080005 sqlite> select count(*) from role where role match '19:10:59'; count(*) 476 CPU Time: user 1.888118 sys 0.036002 Why these are too slow and how last queries are interpretated by FTS3? Why results are different? -- 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