它会动态地缓存内存中的结果集,从而减轻执行“Select”操作的查询和存储过程的负载,进而减少读取操作的反应时间以及总体上的数据库负载。
It offloads the read queries and stored procedures which perform "Select" by dynamically caching in-memory result sets, thereby reducing read response time and overall database load.
直接使用SQL会使缓存出问题,因为缓存层必须处理完整的结果集,而不是单独一个数据库行。
Directly using SQL makes caching problematic, since the caching layer must deal with full result sets rather than single database rows.
结果集最初会被存储在缓存中,随后产生所需的输出。
The result set will initially be stored in the cache to subsequently produce the desired output.
因为预先缓存了来自[HistoricSales]数据集的查询结果,所以整个时间段的销售数据执行的查询性能得到了改善。
Because query results from the [HistoricSales] cube are pre-cached, the performance for queries that are run against the sales data of the entire time period is improved.
缓存适当的数据,如相对静态的网页,明确的输出数据的条目,存储过程参数和查询结果集等。
Cache appropriate data such as relatively static Web pages, specific items of output data, stored procedure parameters, and query results.
当同一个查询被多次执行时,结果集可以直接从缓存中获取,非常快速。
When the same query is executed multiple times, the result is fetched from the cache, which is quite fast.
使用JDBC扩展包中的行集来缓存结果集;
这个调用会让查询在执行时去从缓存中查找结果,或者把结果集放到缓存去。
This call allows the query to look for existing cache results or add its results to the cache when it is executed.
这个调用会让查询在执行时去从缓存中查找结果,或者把结果集放到缓存去。
This call allows the query to look for existing cache results or add its results to the cache when it is executed.
应用推荐