I did not add indices on those columns assuming that being PK is enough? is that right?
On Sat, Oct 2, 2010 at 3:08 PM, Drake Wilson <dr...@begriffli.ch> wrote: > Quoth Fadhel Al-Hashim <fad...@gmail.com>, on 2010-10-02 14:51:59 +0300: > > trying A.x<>B.x AND A.y<>B.y AND A.z<>B.z would just > > hang. > > Huh? How are you using that expression? > > I'd use DELETE FROM a WHERE NOT EXISTS (SELECT * FROM b WHERE a.key = > b.key) > with a suitable composite equality in the subselect. > > > Is my data too big for SQLIte? is it really hanging or it could be taking > 3 > > days? > > Table A and (particularly) table B both have indices on those columns, > right? > > ---> Drake Wilson > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users