NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: pcrafton on March 31, 2008, 04:17:02 PM

Title: where do I put prop:sql to speed up my select?
Post by: pcrafton on March 31, 2008, 04:17:02 PM

Where would I put a Prop:Sql SELECT statement in the WebBrowse for record retrieval? If I am not mistaken that would speed up retrieval of my browse records. SQL seem to run fairly slow if I use Prop:filter.

Regards

Paul Crafton
PTS Solutions

Title: Re: where do I put prop:sql to speed up my select?
Post by: Bruce on March 31, 2008, 08:25:06 PM

Hi Paul,

What does your filter look like? The most common cause of slow browses is incorrect filter statements.

Also, since the browse is based on a VIEW (just like a normal Clarion browse) it would seem to me that you're better off using Prop:SqlFilter over Prop:Sql. Or better yet the SQL() funtion. See normal Clarion docs for more help on SQL().

In terms of placement - right click on the browse procedure and search for LOOP. This is the start of the browse loop, and you'll see code (and embed points) right before it where the filter can be set.

Cheers
Bruce

Title: Re: where do I put prop:sql to speed up my select?
Post by: pcrafton on April 01, 2008, 09:53:57 AM

Bruce:

as per normal you are a genius with the quick reply.

Paul