I am more interesting in theoretical answer :) On Fri, Apr 25, 2008 at 5:24 PM, Federico Granata <[EMAIL PROTECTED]> wrote: > If you are under linux you can use "time" command to execute sqlite with > various query and see which one is faster. > > -- > [image: Just A Little Bit Of > Geekness]<http://feeds.feedburner.com/%7Er/JustALittleBitOfGeekness/%7E6/1> > Le tre grandi virtù di un programmatore: pigrizia, impazienza e arroganza. > (Larry Wall). > > On Fri, Apr 25, 2008 at 10:04 AM, Alexander Batyrshin <[EMAIL PROTECTED]> > wrote: > > > > > Hello people, > > > > I have two SQL commands doing the same thing: > > 1. > > SELECT id FROM foo WHERE expr1 > > EXCEPT > > SELECT id FROM bar WHERE expr2 > > > > 2. > > SELECT id FROM foo WHERE expr1 AND id not IN (SELECT id FTOM bar WHERE > > expr2) > > > > > > Can you say which one is faster? I prefer second option because I can > > use extra condition like LIMIT. > > > > -- > > Alexander Batyrshin aka bash > > bash = Biomechanica Artificial Sabotage Humanoid > > _______________________________________________ > > 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 >
-- Alexander Batyrshin aka bash bash = Biomechanica Artificial Sabotage Humanoid _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users