When we do the revamp for 3.5, we can include the Hibernate indexes so that the DDL is generated automatically. That might help also.
On Tue, May 4, 2010 at 3:49 PM, Marvin Addison <[email protected]>wrote: > > 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 > -- 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
