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

Collapse
2: Re: Notifications: weird outer join to notification_user_map (response to 1)
Posted by C. R. Oldham on 11/19/03 05:39 PM
Yes, on our system, where we make HEAVY use of notifications this query was being fired off every 15 minutes, but it would not complete in 15 minutes.  It was pegging our Oracle server at 100% CPU.

I think we made some optimizations to fix this, but I'm not sure if they got submitted as patches.  Hopefully Brad or Jon Griffin will chime in here and remind me what we did in the end.

Yep, it was really nasty.

Collapse
3: Re: Notifications: weird outer join to notification_user_map (response to 2)
Posted by Dirk Gomez on 11/19/03 05:41 PM
So is the outer join necessary or not?
Collapse
4: Re: Notifications: weird outer join to notification_user_map (response to 3)
Posted by Dirk Gomez on 11/19/03 05:48 PM
And could you post your query please. Is is located in notifications/tcl/sweep-procs-oracle.xql.

Thanks a lot.