Emad, I would suggest that you have a look at the workflow behind this form.
Specifically, I would suggest that you check to see if there are any filters that fire on a Delete, and if these have any searches performed as a result of the delete operation on either the same table or other tables that are heavily populated. If there are searches performed, it would help to see if the key fields used in the searches are indexed. If they aren't indexed I would advise you to index them. Then try the operation.. See you in New York when you visit. Let me know how your travel plans unfold.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Emad Zaky Sent: Tuesday, September 04, 2007 5:49 PM To: [email protected] Subject: That Stupid CTM:AuditLogSystem Form!!! ** Hi All, I hate the CTM:AuditLogSystem form. It grows and grows with useless data...never stops... It has reached 1.4 million records and counting. I would like to delete the entries because backups take 2 hours now. I can't do it from the User tool, I tried to delete using ARUtilities, but nothing...an hour glass and the number of records is the same... So any ideas, how can I do it from the DB level? Regards, Emad No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.485 / Virus Database: 269.13.5/989 - Release Date: 9/4/2007 5:54 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
