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

      Third-party Antivirus and firewall programs can sometimes interfere with the functionality of CurrentWare. If you have any 3rd party antivirus or firewall installed on your client computers, we recommend adding the following CurrentWare files to your ...

    • My database is corrupted. How do I repair it?

      When you are unable to start the cwServer service, there is a chance that your database is corrupted. In order to start the cwServer service again, you will need to repair your existing database. Launch the CurrentWare Server Manager from the ...

    • 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: ...