About Cacheable SQL Statements

Cacheable SQL Statements are often used when accessing essentially static data from SQL Server (such as the metadata defining page layouts). When the data is first requested, it is retrieved from SQL Server, and the results are also copied to the web server memory or the web server disk. Subsequent requests for that exact data are able to use this locally stored copy rather than retrieving it again from SQL Server. These statements save time and help system performance.

As they are creating these Cacheable SQL Statements, netFORUM developers embed comments that will help with testing and evaluating cache performance and behavior. To see these comments, configure the web.config file in each of the netFORUM applications (i.e. iWeb, eWeb and xWeb). Configuring the web.config file adds the hard-coded comments to the SQL statements generated by your netFORUM activity. After that, you must set your netFORUM User Preferences so that you can view these comments. See the Identifying Cacheable SQL Statements topic for specific steps.