Difference between revisions of "Performance Tweaks"
Jump to navigation
Jump to search
(Created page with "Like all software, PTS 5 is not immune to occasional temporary performance issues. =Symptoms= Various functions of the PTS application take a long time to load or to process. =Common causes= <ol> <li>The database has grown large and the data has become fragmented.</li> <li>Printer settings are not optimal.</li> <li>Other software on a shared server is hogging resources.</li> <li>An unoptimised or expensive third party query is hitting the PTS database.</li> <li>The serve...") |
|||
Line 1: | Line 1: | ||
Like all software, PTS 5 is not immune to occasional temporary performance issues. | Like all software, PTS 5 is not immune to occasional temporary performance issues. | ||
=Symptoms= | =Symptoms= | ||
Various functions of the PTS application take | Various functions of the PTS application take an unsatisfactory amount of time to load or to process. | ||
=Common causes= | =Common causes= | ||
<ol> | <ol> |
Revision as of 13:12, 19 July 2022
Like all software, PTS 5 is not immune to occasional temporary performance issues.
Symptoms
Various functions of the PTS application take an unsatisfactory amount of time to load or to process.
Common causes
- The database has grown large and the data has become fragmented.
- Printer settings are not optimal.
- Other software on a shared server is hogging resources.
- An unoptimised or expensive third party query is hitting the PTS database.
- The server/s only meet the bare minimum hardware requirements.
Solutions
- Index the PTS database.
- Turn off bi-directional support.
- Use a resource monitor or the SQL performance dashboard to identify the application at fault and then contact the manufacturer.
- Use SQL performance dashboard to identify the expensive query and have IT or the manufacturer optimise it and/or reduce its frequency.
- Consider upgrading your server hardware to the recommended PTS 5 specification.