On 20 Jun 2010, at 10:40pm, Sam Carleton wrote:

> I am getting the EXACT same result, it calls findImage on for EVERY
> row in the result set.  The goal is to have the findImage()
> short-circuit the where clause so that once it returns 1 one time, it
> stops.  Aka lots of 0's can be returned, but only one 1.

Then forget the fancy clause and just use LIMIT 1.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to