官术网_书友最值得收藏!

Caching

Yet another place where server-side programming can be used is to cache values, which are expensive to compute. The following is the basic pattern here:

  1. Check whether the value is cached.
  2. If it isn't, or the value is too old, compute and cache it.
  3. Return the cached value.

For example, calculating the sales for a company is the perfect item to cache. Perhaps, a large retail company has 1,000 stores with potentially millions of individual sales' transactions per day. If the corporate headquarters is looking for sales' trends, it is much more efficient if the daily sales numbers are precalculated at the store level instead of summing up millions of daily transactions.

If the value is simple, such as looking up a user's information from a single table based on the user ID, you don't need to do anything. The value gets cached in PostgreSQL's internal page cache, and all lookups to it are so fast that even on a very fast network, most of the time is spent doing the lookups in the network and not in the actual lookup. In such a case, getting data from a PostgreSQL database is as fast as getting it from any other in-memory cache (such as memcached) but without any extra overhead in managing the cache.

Another use case of caching is to implement materialized views. These are views that are precomputed only when required, not every time one selects data from the view. Some SQL databases have materialized views as separate database objects, but in the PostgreSQL versions prior to 9.3, you have to do it yourself using other database features to automate the whole process.

主站蜘蛛池模板: 隆回县| 石屏县| 合江县| 仁布县| 香河县| 花莲县| 新宾| 澜沧| 开江县| 滨州市| 铜山县| 黄山市| 山丹县| 邳州市| 华坪县| 郴州市| 通州市| 蒙城县| 灵台县| 灯塔市| 汝阳县| 华阴市| 宿迁市| 咸丰县| 健康| 金山区| 乐至县| 岚皋县| 黑龙江省| 开远市| 东乡族自治县| 万宁市| 台州市| 仁寿县| 台南县| 琼中| 普兰店市| 双城市| 贺兰县| 巴南区| 峨眉山市|