versaSRS Knowledge Base

 

 


versaSRS v7 Database Performance Pack

Article ID: Q731380

Category: versaSRS Tips & Tricks

The information in this article applies to:

  • versaSRS V7
  • Database Maintenance
  • Database Performance
After upgrading to versaSRS version 7 the application is running quite slowly.
Downloading the attached zip file and running the scripts on the versaSRS database will create the necessary indexes to improve the database performance.

Ensure these scripts are executed in the folder and file order they are listed. These scripts will take a long time to run and the database log will grow exponentially, there is a script which will shrink the database.

NOTE: VersaDev takes no responsibility for any data corruption or loss incurred, be sure to take extra care not to remove or change any data by mistake when running queries/scripts directly on the database, we recommend performing a backup and implementing on a test environment before performing on production.

Did the information in this article help answer your question?

Yes
No
Did not apply


Last Reviewed: 24/06/2022
Powered By VersaDev Pty Ltd Copyright 2022
Last Reviewed 24/06/2022

Print this page  Print this page
Click link to send to a friend  Send to a friend
Add to Favorites  Add to Favorites

Provided by
VersaDev Support Services