Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Archiving HR history

 1 Replies
 1 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Linda Wilson
Basic Member
Posts: 5
Basic Member
2/1/2016 5:51 PM

    Hello, we are considering archiving HR history and Personnel action history in an attempt to improve system performance.  Wondering if any other Lawson customers have done this, and if so, did you run into any unintended consequences?  thanks

     

    John Henley
    Posts: 3353
    2/1/2016 8:05 PM
      How many records to you have in HRHISTORY?
      How far back does the history go?
      What are the performance issues you are encountering, and what version are you on?
      Have you tried rebuilding indexes on HRHISTORY and PERSACTHST first?
      I've found that to often solve performance issues related to HRHISTORY, particularly reporting via SQL tools like Crystal, etc.
      Thanks for using the LawsonGuru.com forums!
      John