· 8 years ago · Aug 30, 2018, 05:10 PM
1SQLite3 slow query parsing
2SELECT field1, field2, ... FROM tambe WHERE (rowid NOT IN (some 60000 rowids));
3
4CREATE TEMPORARY TABLE IF NOT EXISTS cache AS SELECT field1, field2, ... FROM tambe WHERE (rowid NOT IN (some 60000 rowids));
5
6IF cache NOT EXISTS (...) END IF;