> 2. We were having some serious database side issues and proformance > problems *until* we indexed the foreign keys in the database on (I > believe) the ticket registry table, and all the problems disappeared.
Man, we _really_ need to document the need for this on the wiki. It's sprinkled all over the place, but it needs to be there in some kind of red info box. We were getting killed with deadlocks on Oracle until we created those indices. M -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
