Trying to use BUFFERS

[Alberto]

Hi, I´m trying to use
BUFFER(Goc:DeCargador_OptionView,100,5,2,300)
adding it at Start of "Option Filter & Order
but it does not work, the page simply hangs.
How can I useit?
Must I use BUFFERS for each file in the view?
Thanks

[Bruce]

Hi Alberto,

Are you using a SQL backend?
The template already generates a buffer statement for you - except in cases where there are "known issues".
For example, the ODBC driver fails if you buffer and the Sort order contains a decimal field.

Cheers
Bruce

[Alberto]

Yes, I´m using MsSql and I´not using any decimal in keys or filters.
I noticed a huge ammount of "duration" with the Profiler in the first or two cursor retreivements and I thought a buffer statement is nedded so I try it.
Which statement are the template using?
Is there any way to moddify it?
Rgards
Alberto

[Bruce]

Right-click on the procedure in the app tree.
choose source.
Search for BUFFER
and you'll see what the template is generating.

You can also put a STOP in to see the value of loc:nobuffer

Cheers
Bruce

[Bruce]

Hi Michelis,

As of PR20 I've removed the BUFFERS setting completely as it caused really weird effects with SQL. I might experiment with it a bit and bring it back in later on.

Cheers
Bruce