Forum OpenACS Q&A: Re: Notifications: weird outer join to notification_user_map

I just got back from out of the country, but the problem was in the exists  vs in thing. The query went to 10 seconds or so.