Clemens, Tim has the same issue as me, while
SELECT EXISTS (select status from mytable where status=1); works the portion in brackets is still executed in full and this is what we are trying to avoid. I am not working directly with the sqlite library but rather though a DAC so I am also limited (no pun intended) there. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 5 March 2016 at 15:12, Clemens Ladisch <clemens at ladisch.de> wrote: > Tim Streater wrote: >> On 05 Mar 2016 at 13:05, Clemens Ladisch <clemens at ladisch.de> wrote: >>> But why do you want to determine the number of rows in the first place? >> >> In my case I want to know whether at least one row exists that has a certain >> column which has a given value. At the minute I do this: >> >> select count(*) from mytable where status=1 limit 1; >> >> Would this: >> >> select count(*) from (select status from mytable where status=1 limit 1); >> >> or some other query be faster. Really, I'd like SQLite to stop after finding >> one row. > > So you want to know whether such a row exists? Then ask for that: > > SELECT EXISTS (select status from mytable where status=1); > > This returns a boolean value. > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
