To me, the biggest pitfall is that there is only one thread for escalations. This is problematic if you use escalations for other processes (such as notifications, record clean-up/deletion, etc) that fight for an open escalation thread. In this case, proper table indexing, archiving/record deletion time staggering and database performance tweaks will all help alleviate some pain.
Thank you, Richard Crosby Starbucks Coffee Company | Information Technology | [EMAIL PROTECTED] | (206) 318-4614 One day your ship will come in, but you'll be at the airport. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"