When it is so easy to test, who cares about theoretical answers? It's been 5 days since you asked and would have taken 5 minutes to test! Try It And See(tm).
On Tue, Apr 29, 2008 at 11:53 AM, Alexander Batyrshin <[EMAIL PROTECTED]> wrote: > 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 > -- Cory Nelson http://www.int64.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users