Welcome back! Ask questions, get answers, and join our large community of tax professionals.
cancel
Showing results for 
Search instead for 
Did you mean: 

DMS Database Performance Enhancement

Intuit Help
Intuit

DMS Database Performance Enhancement

Removing old empty folders will result in a noticeable performance increase and decrease the size of the DMS Database.

At the beginning of each new tax season we release a new version of DMS. When you first go into this new version of the program it will prompt users to add the new tax year folder to the folder template for the upcoming tax year. After adding new tax year folders repeatedly over the years clients will be left with a considerable amount of empty folders that will never be used. These empty folders increase the size of the DMS database by as much as 40%. This size increase affects the performance of DMS. It is recommended to only keep the current tax year folder and the two prior tax year folders in the folder template.

Before You Begin:

  • Ensure you are DMS version 18.1.4.
    • To check your version of DMS, go Help and click About DMS.
    • If you on a version older than 18.1.4, go to Tools and click Internet Updates to update your program.
  • Ensure you have a current backup of your DMS Database.
  • Ensure all users out of DMS.
  • It is recommended to run DMS locally from the computer where the DMS database resides.  Note: Network users will run DMS on the server.

Note: The following steps will not result in data loss. DMS will never delete a folder where files reside.

If at any point you encounter any database errors when completing the steps in this article, exit the program and run the DMS Database Maintenance -  How to run DMS DBRepair.

Follow these steps to improve DMS performance by removing your old empty folders:

Use the Archive feature to identify all prior Tax Year folders.

  1. Open DMS.
  2. Click on the File menu.
  3. Select Archive.
  4. Click No when prompted to run the Database Maintenance.
  5. Click the Collapse button.

  1. Scroll down until you see the TY folders. 

  1. Once you have noted how far back your list of tax year folders goes back you can, click Cancel to close this window.

 

 

  1. Click on Tools menu.
  2. Select Options.
  3. Click the Folder Templates tab within the DMS Options window.
  4. Note the years listed in the template.

Example: In this image we have the current and two prior years which is the setting recommendation.

You will be adding TY folders to Folder Templates until it matches the list of TY folders in the archive window. Based on this example, you will need to add folders going back to TY03.

  1. Mark NO to Do you want to apply changes to ALL clients?.
  2. In the Subfolders to create for new clients, click the top item listed which is Client.
  3. Click the Add button, this will create a folder titled New Folder.
  4. Rename this folder to be the next TY folder that should be listed in your Folder Template.

Example: In this image we will name it TY15.

  1. Click on the top level folder named Client once again and repeat these steps until all of the folders needed match what is listed in the archive window.

Example: In this image we will add TY15 going back all the way to TY03.

Note: It is not necessary to add the subfolders to each TY folder. We only need the top level TY folders.

  1. Before clicking anything else, verify that Do you want to apply changes to ALL clients? is set to NO.
  2. Click OK.

The following dialogue box will be displayed.

  1. Click Continue to add the folder templates.

Note: This process should go fairly fast. Once the window closes the process is complete.

 

  1. Click Continue to add the folder templates. Note: This process should go fairly fast. Once the window closes the process is complete.
  2. Click on Tools menu.
  3. Select Settings.
  4. Select Folder Template. This time verify Do you want to apply changes to ALL clients? is set to YES.
  5. Click on the oldest folder listed in the Folder Templates (In our example it is TY03).

  1. Click the Delete button.
  2. The following dialog box will appear. Click Yes.

Note: It is important to note as the dialog box states DMS will not delete any folders if files exist inside of them.

  1. Continue removing prior year tax year folders until you are left with the current tax year and the two prior as shown below.

  1. Once you are finished removing folders click the OK button to continue.

The following dialogue box will be displayed.

  1. Click Continue and the folder removal process will begin. Note: Once you click Continue it will take a considerable amount of time.
  2. Once it completes it is important to run DBRepair to clean up the database.  Performance improvement will not take place until after DBRepair has ran.  Follow this link for directions to run DBRepair: DMS Database Maintenance
  3. Once DBRepair has completed all users can go back into the program.

After following the steps provided an added step should be followed when creating the new tax year folder to the folder template.

The oldest tax year folder should be removed from the folder template. When this folder is removed please verify that Do you want to apply changes to ALL clients? is set to YES.

This will keep the DMS database from getting cluttered with empty folders moving forward.

Was this helpful?

You must sign in to vote, reply, or post

Related to this Article