Who's On?

	Membership:
	Latest: HireIQ
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5264

	People Online:
	Visitors: 327
	Members: 0
	Total: 327

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

Archiving HR history

1 Replies

1 Subscribed to this topic

68 Subscribed to this forum

Sort:

Author

Messages

Linda Wilson

Basic Member Send Private Message

Posts: 5

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: 3351

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.