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

On Feb 23, 2006, at 11:23, Piotras wrote:
> What limit and offset?

These:

http://www.midgard-project.org/api-docs/midcom/dev/midcom/ 
midcom_core_querybuilder.html#set_limit

> 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.

It is a must here. On my example forum just getting post count for  
100 threads takes about 7 secs (without ACLs or metadata checked).

This is one of the very few cases where old API was actually faster  
than QB.

> Piotras

/Bergie

Henri Bergius
Consultant Partner, Nemein
henri.bergius-ZpG/[email protected]

Midgard CMS
www.midgard-project.org