3 Replies Latest reply on Nov 11, 2014 4:37 AM by jasoncadman

    Is it safe to delete the rows from some of the tables?

    Apprentice

      Hy; Like the below tables which contains the data... is it safe to delete the records.

       

      #1 tps_attachment_data  (attachments, can remove the rows of old and closed incidents)

       

      #2 tps_user_session (auto fill - so it stores the new records depending on the usage - I guess this is safe to delete rows)

       

      #3 tps_user_message  (auto fill - so it stores the new records depending on the usage - I guess this is safe to delete rows)

       

      #4 pm_process_assignment (not entirely sure - but i feel to delete the rows related to #1)

       

      #5 tps_audit_trail (not entirely sure - but i feel to delete the rows related to #1)

       

      For now, the sum of the size of these tables is like 2.7 GB (its not about the size, but unnecessary size, and can be removed)

       

      What say?

       

      (Btw; what plans you have for database maintenance?)

       

       

      /r ww /n RMudugal