You’re offline. This is a read only version of the page.
80
After 5 months of Payroll with GP 10.0, searches in Payroll Transactions Smartlists take forever...(literally), while running the same search as a query directly in SQL Server Manager Studio takes 1-2 seconds, if not instant...
The search criteria is very simple: employee id and check date.
What should we tune up or what could be wrong?
*This post is locked for comments
We had this issue as well. Our solution is to create a smartlist via smartlist builder that restricts the entries to the current quarter. That way the smartlist is only searching (at most) three months of activity. Employees know to use the original Payroll Transations smartlist if they need to go back to a previous quarter.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
