On 12 Nov 2013, at 9:41pm, Igor Korot <ikoro...@gmail.com> wrote:

> I don't see what is wrong. It should be using foreign key constraints
> on the last two searches, but it looks like it does not.

Did you actually create the indexes which would be useful for those 
constraints, or did you just specify the constraints ?

<http://www.sqlite.org/foreignkeys.html#fk_indexes>

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

Reply via email to