What is DB caching in CWSM?

What is DB caching in CWSM?

The button to clear Database Cache is a best practice query that will run on your CurrentWare SQL Database to improve performance of table load times within your CurrentWare Console.

It will run the “exec sp_updatestats” command which is used to update statistics for all user-defined tables in a database. Statistics are used by the query optimizer to estimate the number of rows that will be returned by a particular query, and to choose the most efficient query plan based on that estimate.

When statistics are outdated, the query optimizer may generate suboptimal query execution plans, leading to slower query performance. By using the “exec sp_updatestats” command to update statistics regularly, you can ensure that the query optimizer has the most up-to-date statistics available to make accurate estimates of the number of rows that will be returned by a query. This can lead to faster query performance and a more responsive database.

To access the “Clear Database Cache” option:

Note: It is recommended to run this outside of peak work hours to avoid any database performance impact.

  1. Open the CurrentWare Server Manager by typing in “CWSM” on the windows search bar or go to C:\Program Files(x86)\CurrentWare\cwServer\CWSM.exe
  2. Select the Database > DB Caching tab.
  3. Click the “Clear Database Cache” tab.

Best Practices for Updating Statistics:

While the “exec sp_updatestats” command is a powerful tool, it should be used with caution. Updating statistics on very large tables can be a time-consuming process, and it can cause performance issues if done during peak usage hours. It is generally recommended to schedule updates during periods of low database usage to minimize the impact on performance.


    • Related Articles

    • Upgrading the CurrentWare database using CWSM.exe

      The command line database upgrade will convert any older CurrentWare database (CWNPFB) to the CurrentWare version that is installed on your computer. For example, if you have CurrentWare v5.5.3 installed on your computer, you can take any older ...

    • Adding CurrentWare to your Antivirus’ Exclusion Lists

      The CurrentWare software is created in a secure environment. All of the files are thoroughly tested and digitally signed by Microsoft. In some cases third-party Antivirus and firewall programs can sometimes interfere with the functionality of ...

    • I am not getting any URLs in my reports

      If you are not seeing any URL data in your reports from BrowseReporter, here are some ways to troubleshoot the issue. Restart the Client Computer If you can’t find any URLs in your reports right after installing the client agent on the computer, a ...

    • How do I connect CurrentWare to my SQL Server?

      From your CurrentWare Server, go to C:\Program Files (x86)\CurrentWare\cwServer\ In this folder you can run the CWSM.exe file. This will bring up the CurrentWare Server Manager. Select Database > Selection > SQL Server. Enter your SQL Server details: ...

    • Adding CurrentWare to your BitDefenders Exclusion Lists

      Bitdefender Antivirus can sometimes interrupt with the functionalities of CurrentWare due to where the local files are hidden on the client PCs. RECOMMENDED: Temporarily Disable Bitdefender Prior to Upgrades If you have any of the Bitdefender ...