We found our PR Pay Period Control form loading painfully slow. As in several minutes which really makes no sense for the purpose of this form. Found that with ADP enabled it is querying a specific table. For us that table has 7M plus records in it and there are no indexes. The procedure loading the form seems to use PRGroup, PRCo and PREndDate as the selection criteria so we create a index on this table and the form loads immediately. I would suggest Viewpoint consider making this index default on this table as part of the software.
Guest
| Company | Team Fishel |
| I need it... | Yesterday...Come on already |
Dear Viewpoint Suggestion Box contributor;
We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs.
Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.
© 2023 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.
We also have SQL reports in Crystal that use the PayPeriodControl and can be quit slow when searching across WeekEnds. An index would help.
Attachments Open full size