如何通过缓存数据库结果提高PHP性能?
清单 7。 使用 PEAR::Cache_Lite 缓存 '/tmp/', 'lifeTime' => 86400 ); if (!isset($_GET['order_no'])) {die('The order_no parameter is required'); } $order_no=$_GET['order_no'];$cache = new Cache_Lite_Function($options);if ($orderfields = $cache->call('getOrderFields', $order_no)){print "ORDER #$order_no\n...全部
清单 7。 使用 PEAR::Cache_Lite 缓存 '/tmp/', 'lifeTime' => 86400 ); if (!isset($_GET['order_no'])) {die('The order_no parameter is required'); } $order_no=$_GET['order_no'];$cache = new Cache_Lite_Function($options);if ($orderfields = $cache->call('getOrderFields', $order_no)){print "ORDER #$order_no\n";print "";print "DATE:"。
$orderfields['ORDER_DATE']。"";print "CUST_ID:"。$orderfields['CUSTOMER_ID']。"";print "TOTAL:"。$orderfields['ORDER_TOTAL']。
"";print "";} else {print "Some problem occurred while getting order fields!\n";$cache->drop('getOrderFields', $order_no); }if (list($nrows, $orderitems) = $cache->call('getOrderItems', $order_no)){//print "LINE ITEMS IN ORDER #$order_no";print "";print "\n";while (list($key, $value) = each($orderitems)) {print "$key\n"; }print "\n";for ($i = 0; $i drop('getOrderItems', $order_no); }?>
“ 清单 7”中的 testCache。
php 脚本应与 order_no URL 参数(代表 OE。ORDER 表中存储的订单 ID)一起被调用。例如,要检索与 ID 为 2408 的订单相关的信息,浏览器将生成以下输出: ORDER #2408。
收起