Go to: File menu > Utilities module > Utilities menu > Database Utilities
Defragmentation
It is beneficial to defragment your VisionVPM indexes on a regular basis, for example each month. This may help if you notice the program is running slowly.
Note: It is important not to interrupt this procedure while it is running.
Ensure everyone is out of VisionVPM.
Run a one off backup.
The following should be performed on your SERVER:
Go to: File menu > Utilities module > Utilities menu > Database Utilities.
In the Performance box select Defragment Indexes and keep the percentage at 10%.
Do not make any other selections.
Click OK.
Leave this to run. We estimate it will take 5 – 40 minutes depending on the size and fragmentation level. It will take longest the first time it is run.
When it has finished a Results dialogue box will be displayed. Click OK, then Close to close out of the Database Utilities window. You are now able to carry on using VisionVPM as normal.
Scanning Data for Faults
This procedure scans for data faults on your VisionVPM database.
Note: It is important not to interrupt this procedure while it is running.
Ensure everyone is out of Vision VPM.
Run a one off backup.
The following should be performed on your SERVER:
Go to: File menu > Utilities module > Utilities menu > Database Utilities.
In the Database Integrity box select Scan for Data Faults.
Leave the selection as Repair Fast No Data Loss.
Do not select any other options.
Click OK.
Leave this to run. We estimate it will take 2 – 20 minutes depending on the database size and speed of your server.
When it has finished a Database Error Details window will be displayed. If there are any allocation errors, a report should be printed off at the bottom of the window and faxed to VisionVPM.
Reindexing
Database tables have indexes to help speed up data access. If there has been database corruption, it is advisable to reindex these tables. To do this, click Reindex Tables in the Database Integrity box.
Shrink Database File
Shrinking a database file is not recommended. The database performs better when expanded.
