NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Alberto on November 20, 2008, 06:42:43 AM

Title: Trying to use BUFFERS
Post by: Alberto on November 20, 2008, 06:42:43 AM

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

Title: Re: Trying to use BUFFERS
Post by: Bruce on November 21, 2008, 12:43:22 AM

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

Title: Re: Trying to use BUFFERS
Post by: Alberto on November 21, 2008, 05:41:23 AM

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

Title: Re: Trying to use BUFFERS
Post by: Bruce on November 24, 2008, 05:25:40 AM

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

Title: Re: Trying to use BUFFERS
Post by: Bruce on November 27, 2008, 11:22:26 PM

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