Hello! The SQLite library is builded from trunk af3b72d94a1b6513f02402af3ada5fb5dd390151
1. With ordinary tables - fast explain query plan select role.rowid as rowid, role.* from role_exist, role where role_exist.rowid=role.rowid; 0|0|TABLE role_exist 1|1|TABLE role USING PRIMARY KEY select role.rowid as rowid, role.* from role_exist, role where role_exist.rowid=role.rowid; ... CPU Time: user 0.000000 sys 0.000000 2. With ordinary tables and virtual table - very slow explain query plan select role_exist.rowid as rowid, role.* from role_exist, role, role_fts where role_exist.rowid=role.rowid and role_exist.rowid=role_fts.rowid; 0|2|TABLE role_fts VIRTUAL TABLE INDEX 0: 1|0|TABLE role_exist USING PRIMARY KEY 2|1|TABLE role USING PRIMARY KEY select role_exist.rowid as rowid, role.* from role_exist, role, role_fts where role_exist.rowid=role.rowid and role_exist.rowid=role_fts.rowid; ^CCPU Time: user 34.058128 sys 1.720108 Error: interrupted 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
