The Dynamic Query Mode must determine whether a result can be stored in the cache using a number of data points collected at runtime.
DynamicQueryMode必须确定一个结果是否可以使用在运行时收集的大量数据点存储到缓存中。
From here on out, until the cache expires, you will be able to fetch the result array directly out of cache, skipping over the SQL query.
从这里开始,直到缓存到期,您就能够直接从缓存中获取结果数组,跳过SQL查询。
The second level cache can also cache your query result.
二级缓存也能缓存查询结果。
Materialized Query Tables (MQTs), formerly known as Automatic Summary Tables (ASTs), can be defined to locally cache the result of queries that reference relational and non-relational nicknames.
可以通过定义物化查询表(Materialized QueryTables, MQT)——以前称为自动总结表(Automatic Summary Tables,AST)——来在本地缓存引用关系和非关系昵称的查询的结果。
MySQL has a feature called the query cache that stores the result of a query in memory, should it be needed again.
MySQL有一个特性称为查询缓存,它将(后面会用到的)查询结果保存在内存中。
When the same query is executed multiple times, the result is fetched from the cache, which is quite fast.
当同一个查询被多次执行时,结果集可以直接从缓存中获取,非常快速。
When the same query is executed multiple times, the result is fetched from the cache, which is quite fast.
当同一个查询被多次执行时,结果集可以直接从缓存中获取,非常快速。
应用推荐