Slow with use block, sub-block and bypage.

Skrol, my name is Marcos Borges, I m using your Template Manager (TBS) all very time, because in my opnion it is the best..

I would like to know if it shows some kind of slow, If i use three  methods (Merge Block + Sub Merge Block + ByPage) ?

I m using TBS  2.05.3 Version with PHP 4.3.11.

Ps. When I use the three methods, the performance application falls down too much.

Best Regards.
Marcos Borges

Hi Marcos,

The ByPage feature is known to be not optimized. Specially if you're using it several times like withing Sub Blocks.
It's better to manager the page display with the features of you Database System. Like the clause LIMIT for MySQL.

As Skrol29 says.
And if you need to know the number of  all rows in a query there is a MySQL trick for that.

There is example ideas for doing paging using TBS NavBar plugin together with LIMIT clause to substitue for ByPage plugin here http://tomhenry.us/tbs3/
look for the "efficient paging" link

HTH

Thanks

Actually are there any tips in optimised usage of tbs?  My in-php log shows that my systems spend most of their time merging, and my profiler reports the same, even without plugin.

It's hard to promote something that's the bottleneck for every of my php apps whenever it is used. =(

I remove all "if [val]" the execution time subblock was from 11 seg to 4 seg. but still it continues slow.

sorry for my bad english, i m Brazilian.

There are some advices in the FAQ:
  http://www.tinybutstrong.com/support.php#faq_slow

I have a system (Flingr.com) which is running the template system fully, and very very fast.  The bypage element needs to use the mySQL limit clause (as does most real-world apps).  Otherwise it's kinda pointless to go by-page using php. 

As for optimizations, try to limit the amount of queries used on a page, and any redundant looping.  Also, cache cache cache!  Don't forget that TBS is by far faster then Smarty btw ;)

Hmm.  I think we need a better context.  Most of my pages can be merged in 0.04-0.07s in development and up to 0.6s on shared live host, which is fast enough for my boss, but that is typically 30% - 60% of total processing time, that's why I asked for tips to make it faster.  It always spend most time on tbs_locator_pmread, meth_locator_replace, and meth_locator_findtbs.  I load all plugins but even if I use none the merging speed up only 10%...

I followed all guidelines on FAQ, so I guess I'll have to start caching page components like caching selected merge result... a new plugin, perhaps? =D