Big excel template and memory problem

Hi,
I'm using Excel plugin with a big template (6MB), and I need to publish my program on a shared server with 12MB but I get a meory limit error.
I know that I'm asking a lot, but:
- I'm merging only variables not blocks.
- Is it possible to load in memory only  part of the template and send it to the browser before load another part?
- How TBS works? Does it search for variable when it read the template or it load all template before and after start to merge any variable sequentially?

Thank you,
Gianluca

Hi,

First I think (not sure) that you have PHP functions that allow you to extent time and memory limits for the current script.

If the big size is due to one or several blocks with many records, then you can try the MergeOnFly plug-in combined with the Excel plug-in. Not tested yet, but may work fine.

> - How TBS works? Does it search for variable when
> it read the template or it load all template before and
> after start to merge any variable sequentially?

[onload.xxx] fields are merged with LoadTemplate()
[var.xxx] fields are merged with Show()

Hi, Skrol29, thanks for your great work of TBS firstly.
Can you give the sample code you mentioned "you can try the MergeOnFly plug-in combined with the Excel plug-in". I have just tried but not work.
Thanks in advance.

Lp

In fact the MergeOnFly plugin works only with the MergeBlock() method. So it  seems this won't help you in anything.

Did you try to extend the memory limitation ?