Support Forum - very, very slow on 2 network stations

10/27/2021 00:34 Sofia wrote:

Hi, 

I have a report that when trying to print on 2 network stations, it gets very,
very slow, up to 50 sec.

The report receives 2 parameters, one string and one real

and it's like this in Before Open View

BIND('LOC:Serie',LOC:Serie)
BIND('LOC:NoFactura',LOC:NoFactura)
BIND('FCV:Serie',FCV:Serie)
BIND('FCV:Id_FacVen',FCV:Id_FacVen)
LOC:Serie     = param:Serie
LOC:NoFactura = param:NoFactura
  IF SELF.Filter = ''
    ImpFacVenMan::View{Prop:Filter} ='FCV:Serie= LOC:Serie AND FCV:Id_FacVen=
LOC:NoFactura'
    IF ERRORCODE()
       STOP(ERROR())
     END
  ELSE
    ImpFacVenMan::View{Prop:Filter} ='FCV:Serie='&LOC:Serie&' AND
FCV:Id_FacVen='&LOC:NoFactura&'AND ' &'('& CLIP(SELF.Filter) &')'
  END

I already saw all the posts that talk about this, I have the sort banding, the
key in my base, and nothing ...

please a real solution to this problem ...

Something like what clarion does with current record !!

11/08/2021 22:17 Oleg Fomin wrote:

Hi Sofia,

Something is suspicious in your code for me.

> The report receives 2 parameters, one string and one real

> ImpFacVenMan::View{Prop:Filter} ='FCV:Serie= LOC:Serie AND FCV:Id_FacVen=
LOC:NoFactura'

This will work Ok with bound variables.

> ImpFacVenMan::View{Prop:Filter} ='FCV:Serie='&LOC:Serie&' AND
FCV:Id_FacVen='&LOC:NoFactura

This will work for numeric but NOT for string variable.

> please a real solution to this problem ...

I wish I could reproduce the issue on my computer to experiment and find out a
cause of the slowness.

At first glance this looks like opportunistic lock issue.

See docs.microsoft.com/en-us/windows/win32/fileio/opportunistic-locks

Name:
E-Mail: (will not be published)
Subject:very, very slow on 2 network stations


Message body:

Verification code:

Please, do not include any URLs into the message.
Otherwise, your message will be rejected and IP blacklisted automatically.
Off topic messages will be deleted by moderator.