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.