版主: 版主管理群
目前該網址掛點中 .. 等待flyinghail 寫:不是這裡，是安裝文件的一処錯誤，主題裏面我也提到過了，這一段要是去掉了那等於根本沒有使用緩存
代碼: 選擇全部
if($query_id)
{
$this->row[$query_id] = @mysql_fetch_array($query_id); 代碼: 選擇全部
if( empty($this->row[$query_id]) )
{
$this->row[$query_id] = @mssql_fetch_array($query_id);
w2812451 寫:太好用了～剛剛用ultraedit把所有的
if( !($result = $db->sql_query($sql)) )
置換成
if( !($result = $db->sql_query($sql, false, true)) )
再進入的讀取畫面(應該有些人有看過，那是預先瀏覽功能)
的時候會有點LAG
開啟index.php花了1秒多
不過重點來了！我重新開啟後，資料庫從32跑到剩下7
原本紀錄的0.053s變成了0.01s
太快了吧！
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
不過再重新開一次，沒用了ˊˋ
可能是...............伺服器凸然秀斗～哈哈
有很多地方沒有必要緩存，這個緩存功能是根據查詢的結果生成的，同樣的結果就會使用同一個緩存，不同的結果第一次會生成一個緩存文件，之後如果沒有新的變化就會使用這個緩存文件了，有些地方好比viewforum.php最主要的那次查詢，瀏覽一次帖子就得重新生成一次緩存，緩存的價值不大，其他一些地方就要有用多了~MacTemplate cacheing
Authors: Crimsonbane, psoTFX and nathan
File Caching Updated
During development of phpBB2 a recurring issue of server load has cropped up. phpBB 2.0.0 differs from many of its contemporaries by doing many more tasks at runtime. While this allows for simpler upgrade and modification paths it also leads to a greater strain being placed on the server. To help reduce this issue a cacheing template system was created based on work by Crimsonbane. This stores a compiled version of each template resulting in a generally significant reduction in server load and perhaps page generation time.
Two versions of the cacheing system are contained in this directory, one uses flat files the other a MySQL database. Testing has shown that, in general, the average virtual host seems to show better performance with the flat file solution. However this may not be the case for your system, so please feel free to try both.
In both cases you need to rename your existing template.php script (in includes/) and replace it with whichever template_*.php you want to try.
這裡面的template_file_cache.php和eXtreme Styles mod用的方法差不多，template_db_cache.php還要增加查詢，需要很好的數據庫服務器，一直在用eXtreme Styles mod所以也就沒有用過template_file_cache.php，比較了下顯示速度是template_file_cache.php快，不過看了下生成的緩存文件，幾乎是一樣的，估計是eXtreme Styles mod本身文件太大、太複雜造成的，實際來説緩存效率應該是相差無幾Mac 寫:可以先試試看一直收藏在 contrib 裡的 Template cacheing 修改法
contrib/README.html
~MacTemplate cacheing
Authors: Crimsonbane, psoTFX and nathan
File Caching Updated
During development of phpBB2 a recurring issue of server load has cropped up. phpBB 2.0.0 differs from many of its contemporaries by doing many more tasks at runtime. While this allows for simpler upgrade and modification paths it also leads to a greater strain being placed on the server. To help reduce this issue a cacheing template system was created based on work by Crimsonbane. This stores a compiled version of each template resulting in a generally significant reduction in server load and perhaps page generation time.
Two versions of the cacheing system are contained in this directory, one uses flat files the other a MySQL database. Testing has shown that, in general, the average virtual host seems to show better performance with the flat file solution. However this may not be the case for your system, so please feel free to try both.
In both cases you need to rename your existing template.php script (in includes/) and replace it with whichever template_*.php you want to try.
Categories Hierarchy 2.1.1 版的緩存技術技術似乎也比前版 2.0.5 RC2 來的更洗練進化了相對于恐怖的Categories Hierarchy（幾乎已經把phpBB改成另一個論壇了）這個MOD使用的緩存技術更通用，而且可以兼容任何的其他MOD
怪哉...你的文件估計有問題吧，你可以從phpbb.com下一個看看吉川拓也 寫:目前該網址掛點中 .. 等待flyinghail 寫:不是這裡，是安裝文件的一処錯誤，主題裏面我也提到過了，這一段要是去掉了那等於根本沒有使用緩存
我不知道我的 mysql.php 檔案是否跟各位相同 ..
因為他要我找的那段 :我的居然是 :代碼: 選擇全部
if($query_id) { $this->row[$query_id] = @mysql_fetch_array($query_id);代碼: 選擇全部
if( empty($this->row[$query_id]) ) { $this->row[$query_id] = @mssql_fetch_array($query_id);
你的server速度不如人家快唄俊俊 寫:我又重裝這個外掛了, 這次終於都成功了
Orz 為什麼吉川大的首頁讀取101次SQL 只用了0.1s 我的只讀取32次就用了0.4s
三.w2812451 寫:目前安裝之紀錄如下
http://bnb.twbbs.org/cached_generation.html
我覺得新手在安裝MOD之前，最好做一下紀錄~~
我現在資料夾裏有97個記錄檔了
每一個都是每次安裝MOD留下的！
所以說我總共記錄了97次的安裝次數～
(意思就是說我共安裝了97種外掛，不過有有刪掉許多！)
代碼: 選擇全部
#
#-----[ OPEN ]------------------------------------------
#
includes/page_tail.php
#
#-----[ FIND ]------------------------------------------
#
'overall_footer' => ( empty($gen_simple_header) ) ? 'overall_footer.tpl' : 'simple_footer.tpl')
);
#
#-----[ AFTER, ADD ]------------------------------------------
#
//
// Cached Generation
//
$timeend = microtime();
$diff = number_format(((substr($timeend,0,9)) + (substr($timeend,-10)) - (substr($timestart,0,9)) - (substr($timestart,-10))),4);
#
#-----[ FIND ]------------------------------------------
#
$template->assign_vars(array(
#
#-----[ AFTER, ADD ]------------------------------------------
#
// Cached Generation
'PAGE_GENERATION' => sprintf($lang['debug_generation'], $diff),
'MYSQL_QUERIES' => sprintf($lang['sql_queries'], $db->num_queries),
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/overall_footer.tpl
#
#-----[ IN-LINE FIND ]------------------------------------------
#
{TRANSLATION_INFO}
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
<br />{PAGE_GENERATION} {MYSQL_QUERIES}
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM 代碼: 選擇全部
#
#-----[ OPEN ]------------------------------------------
#
language/你的語系/lang_main.php
#
#-----[ FIND ]------------------------------------------
#
?>
#
#-----[ BEFORE, ADD ]------------------------------------------
#
//
// Cached generation
//
$lang['debug_generation'] = '頁面生成時間: %s 秒';
$lang['sql_queries'] = '共讀取資料庫: %s ';
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM