[pLog-svn] Improving performance of summary.php

Oscar Renalias oscar at renalias.net
Sun Nov 27 13:24:21 GMT 2005


Let's face it, summary.php is still slow :-)

I was thinking about this and I found two possible solutions (that  
are not mutually exclusive, by the way):

- Somebody logged a feature request in mantis asking for summary  
templates that are not removed when a change in data occurs, but  
instead, that expire after a certain period of time. Something like  
15 min or so. This would confuse some users but we would only need to  
generate the front page 4 times per hour, instead of many more in  
case of busy sites.

- Instead of calculating the lists of most recent and commented  
articles, blogs, etc every time we generate the front page of  
summary.php, we should calculate these lists every time somebody  
posts, updates or deletes an article and then  store the id of these  
articles and blogs in some temporary table. This would slow down  
operations with blog articles but should theoretically speed up  
loading summary.php.

I haven't tested any of these approaches yet. But does anyone have  
any comments or further ideas?

Oscar



More information about the pLog-svn mailing list