Slow browse with locator

[oggy]

I have a couple of browses with position locator, page loaded. When I disable locator, refreshing and displaying browse is almost instantenously. With locator enabled, all goes painfully slow. Without any filtering, to display that browse, first time after loging into app, takes about 4 seconds, the table is some 50 000 records. Closing this browse, and re-opening it, all goes even slower, about 15 seconds to open that browse...
In contrary, another browse on same table, but with filter, page loaded also, take about second or two to open...
Any help?
NT5.47, C8,
Regards, Ozren.

[Bruce]

Hi Ozren,

the way to debug this is to "see" what the contents of the Prop:Order and Prop:Filter for the VIEW are.

The easiest way to do this is to add trace lines right before the LOOP statement in the browse;

  p_web._trace('ORDER: ' & thisview{prop:order})
  p_web._trace('FILTER: ' & thisview{prop:filter})

then the properties appear in debugview.

If you post the results here then we can comment, make suggestions and so on.

the most common case has to do with the keys you have in your dict - but there are other factors as well.

cheers
Bruce

[oggy]

Here is log file...
Regards, Ozren

[attachment deleted by admin]

[Bruce]

Hi Ozzy,

way too much information mate. turn logging off (global extension).
We just want to see the Prop:order and Prop:filter. So paste those 2 lines in here. (no need to even make an attachment.)

cheers
Bruce

[oggy]

Heh, sorry,  ,

00001357   9.68934441   [3464] [netTrace][thread=3] ORDER: UPPER(MRL:NAZIV),MRL:SIF_ART   
00001358   9.68936825   [3464] [netTrace][thread=3] FILTER: Upper(MRL:SIF_POD)='001' AND Upper(MRL:GDOK)='2011'