[pLog-svn] Improving performance of summary.php

[Oscar Renalias]

The feature is already in place. That was an easy one :-)

Oscar

On 27 Nov 2005, at 20:19, Mark Wu wrote:

> I sounds great. :D
>
> Mark
>
> -----Original Message-----
> From: plog-svn-bounces at devel.lifetype.net
> [mailto:plog-svn-bounces at devel.lifetype.net] On Behalf Of Oscar  
> Renalias
> Sent: Monday, November 28, 2005 1:20 AM
> To: plog-svn at devel.lifetype.net
> Subject: Re: [pLog-svn] Improving performance of summary.php
>
>
> On 27 Nov 2005, at 17:01, Mark Wu wrote:
>
>> Hi Oscar:
>>
>> I prefer the first way.
>>
>> I discussed this issue with pixnet's(biggest photo sharing site in
>> Taiwan)
>> adminstrator before, he told me he generate these information 1 time
>> per hour. He suggest us doing this in 2 levels:
>>
>> 1. Setting a time fence (can changed by administrator), when user
>> launch the summary page, summary page will check the cache is expired
>> or not, if yes, summary page will caculate these information again.
>> (The generate process still controlled by PHP thread, sometimes it
>> will slow down someone's speed, we don't know who)
>
> This is actually easier than it seems. Smarty's implementation of a  
> cache
> includes a lifetime for cached pages, so all we need to do  is set the
> lifetime to the same value that an admin set in the user interface.  
> Smarty
> will take care of resetting the page when needed.
>
> We do need a few changes in CacheCotrol, to avoid resetting the  
> summary
> cache if the configured lifetime is greater than 0.
>
>>
>> 2. The same as above, but use another program (PHP script, or other
>> script)
>> to generate this summary page cache and controlled by cron tab.
>> (This way is
>> more effective for big site) --> Pixnet use this way.
>>
>
> I think these two options can work together: admins configure the
> lifetime of the summary page to let's say, 15min, and then a cron
> script runs every 15min and 1sec to automatically rebuild the page.
> This would avoid the possibility of somebody getting a slow summary
> page...
>
> Oscar
>
>> Mark
>>
>>
>> -----Original Message-----
>> From: plog-svn-bounces at devel.lifetype.net
>> [mailto:plog-svn-bounces at devel.lifetype.net] On Behalf Of Oscar
>> Renalias
>> Sent: Sunday, November 27, 2005 9:24 PM
>> To: plog-svn at devel.lifetype.net
>> Subject: [pLog-svn] Improving performance of summary.php
>>
>> 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
>> _______________________________________________
>> pLog-svn mailing list
>> pLog-svn at devel.lifetype.net
>> http://devel.plogworld.net/mailman/listinfo/plog-svn
>>
>> _______________________________________________
>> pLog-svn mailing list
>> pLog-svn at devel.lifetype.net
>> http://devel.plogworld.net/mailman/listinfo/plog-svn
>>
>
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.plogworld.net/mailman/listinfo/plog-svn
>
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.plogworld.net/mailman/listinfo/plog-svn
>