Re: More efficient forum, was Re: [midgard-dev] QB count method

Henri Bergius <henri.bergius-ZpG/[email protected]> wrote:

> ## Thread listing
> 
> The thread listing can be made more efficient using the following  
> methods:
>    * Page the listing using the org.openpsa.qbpager library
>      (not that big advantage since limit and offset are coming from  
> PHP level)

What limit and offset? 

>    * Cache the number of posts into the thread
>    * Cache either the latest post GUID or basic info (poster, title,  
> date) into
>      the thread

You want to define some object's property and some column in table to store 
number of "childs" and update them when new post is added?
 
Probably a stupid idea but sometimes it's very handy to create poor cache like 
solution where pure html output is written to. So if the page should contain full thread
view it's content should be written while thread is updated.
Usually it's like 1 to 50 if you think about performance.

Piotras