Announcements

 View Only

Tip of the Day: Tricks for Increasing Performance of a Masking Job

  Thread closed by the administrator, not accepting new replies.
  • 1.  Tip of the Day: Tricks for Increasing Performance of a Masking Job

    Posted 01-05-2015 05:48:00 PM
    No replies, thread closed.
    Please note that these are some tricks/tips for increasing Masking Performance Only

    - Disable Logging for the database, if not at least for the tables which are getting masked
    - Changing commit sizes (20K seems to work best)
    - Changing Update Threads (5 seems to be optimal)
    - Dropping Indexes
    - Disabling Contraints, triggers
    - Splitting the rows into multiple jobs and run parallel

    #Tip