Mark,

>select v_peoplepicturescount.*
>from people sel_people
>left join v_peoplepicturescount on v_peoplepicturescount.pid=sel_people.pid

why do you do a left (outer) join here? The view itself already contains a
left join for the people table, so it will match every occurence. I don't
know if it will help any, but changing to

select v_peoplepicturescount.*
from people sel_people
join v_peoplepicturescount on v_peoplepicturescount.pid=sel_people.pid

should yield the same result.

Set