Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#13 Yesterday 12:25:09

etc
Developer
Registered: 2010-11-11
Posts: 5,526
Website GitHub

Re: [Solved] Count a same occurrence into titles

Good question, limit could be faster than COUNT(). But the fastest is EXISTS() query, it might be useful to implement it somehow.

Offline

#14 Today 15:36:27

etc
Developer
Registered: 2010-11-11
Posts: 5,526
Website GitHub

Re: [Solved] Count a same occurrence into titles

Now one can optimise counting:

<!-- only checks whether articles exist, returns true or false -->
<txp:article_custom pgonly pageby="0" limit="0" />

<!-- counts up to 3, instead of scanning all articles, returns 0, 1, 2, 3 -->
<txp:article_custom pgonly pageby="0" limit="3" />

Offline

Board footer

Powered by FluxBB