Ok, so this morning we dropped and recreated the TICKETGRANTINGTICKET and SERVICETICKET tables in our production environment. It still does not look like any records in the TICKETGRANTINGTICKET table are getting cleaned up after 2 hours. There are rows in there from 4:00AM this morning that should have been cleaned up by now.
What is interesting though, is that we have the same code on a development server, and it does clean up the old rows after 2 hours. Thanks -----Original Message----- From: Marvin Addison [mailto:[email protected]] Sent: Thursday, April 17, 2014 11:58 AM To: [email protected] Subject: Re: [cas-user] TGT table not getting cleaned up > This select though is very expensive, per our DBA's. Could it be because > there are over 4 million rows? Yes. Don't believe there's an index on TICKETGRANTINGTICKET_ID. Any query on an un-indexed column on a table that size would be expensive. 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
