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
