jose isaias cabrera wrote: > now this command is working perfectly: > > BEGIN; INSERT OR REPLACE INTO LSOpenProjects > SELECT * FROM client.LSOpenProjects WHERE id IN > (SELECT id from LSOpenProjects WHERE > login != '20513925' AND > id = client.LSOpenProjects.id > AND XtraB != client.LSOpenProjects.XtraB > ); > END; > > But, it is taking a real long time. This is the EXPLAIN QUERY PLAN for it: > > sqlite> EXPLAIN INSERT ...
This is not the EXPLAIN QUERY PLAN output. What is the database schema? Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
