Thanks, I'll forward this to my DBAs. >That's the query to load all the child tickets for a given TGT. >Recall proxy-granting tickets are modeled as children of a parent TGT.
Hmmm, we are using Service Manager and I have allowed proxy on all entries. But we don't have any apps really using proxy. Perhaps I should disable this? >That sounds like a heck of a lot. Do you have ~2M concurrent users? >That would be a very large CAS install if so. Not even close to 2 mil. 30k students and 20k employees. I doubt if they are all logged in at one time. We do have a very generous inactivity timeout of 10 hours and a hard time out of 12 hours. Could this be affecting this? >What platform is this again? Glassfish 3.0.1 with Oracle DB. I am using the c3p0 pooling. >This would be perfectly normal if you're not issuing proxy tickets. Yep we don't use proxy. > Why is it executing Code against a Large tables where it will always return > ZERO Rows? Presumably because you don't use proxy tickets, but the application is coded to handle the case where they would be used. Hopefully your slowness is caused simply by missing or misconfigured 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
