Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #3755 > unrolled thread

Got a handle on our screen update issue

Started byMartin <spam@spam.spam>
First post2012-07-12 16:51 +0100
Last post2012-08-10 10:51 +0200
Articles 8 — 6 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  Got a handle on our screen update issue Martin <spam@spam.spam> - 2012-07-12 16:51 +0100
    Re: Got a handle on our screen update issue "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-07-13 02:42 +1000
      Re: Got a handle on our screen update issue Martin <spam@spam.spam> - 2012-07-13 10:13 +0100
        Re: Got a handle on our screen update issue Johan Nel <johan.nel@xsinet.co.za> - 2012-07-13 03:40 -0700
          Re: Got a handle on our screen update issue Martin <spam@spam.spam> - 2012-07-13 15:27 +0100
            Re: Got a handle on our screen update issue "richard.townsendrose" <richard.townsendrose@gmail.com> - 2012-07-15 04:37 -0700
    Re: Got a handle on our screen update issue Mathias <mathias.hakansson@consultec.se> - 2012-08-08 22:57 -0700
    Re: Got a handle on our screen update issue "Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it> - 2012-08-10 10:51 +0200

#3755 — Got a handle on our screen update issue

FromMartin <spam@spam.spam>
Date2012-07-12 16:51 +0100
SubjectGot a handle on our screen update issue
Message-ID<MnCLr.637736$8G5.132795@fx12.am4>
Still not sure if it is, but we managed to get similar issues using 
large array servers.

I had a 2000 row 35 column array server and the program would used 3MB 
or similar and after a while the screen updates would take ages.

We do use CollectForced() as well.

2.7 appears to be fine 2.8 gets blank screens, they populate a while 
(minutes) later.

bArrayServer large loads appear to set it off

I will be fixing this issue with more temporary files.

Martin

[toc] | [next] | [standalone]


#3756

From"Stephen Quinn" <stevejqNO@bigpondSPAM.net.au>
Date2012-07-13 02:42 +1000
Message-ID<69DLr.353$Oq4.229@viwinnwfe02.internal.bigpond.com>
In reply to#3755
Martin

> I had a 2000 row 35 column array server and the program would used 3MB

I'd be asking why you need 2000 rows in an arrayserver.

CYA
Steve 

[toc] | [prev] | [next] | [standalone]


#3764

FromMartin <spam@spam.spam>
Date2012-07-13 10:13 +0100
Message-ID<_ERLr.797007$BJ1.85072@fx25.am4>
In reply to#3756
Because the data came from more than one DBF and wanted to be sortable 
of fields which were only existing during display.



On 12/07/2012 17:42, Stephen Quinn wrote:
> Martin
>
>> I had a 2000 row 35 column array server and the program would used 3MB
>
> I'd be asking why you need 2000 rows in an arrayserver.
>
> CYA
> Steve
>
>

[toc] | [prev] | [next] | [standalone]


#3765

FromJohan Nel <johan.nel@xsinet.co.za>
Date2012-07-13 03:40 -0700
Message-ID<50707c99-bfbd-4d69-8f4e-061e445a1c09@s9g2000vbg.googlegroups.com>
In reply to#3764
Martin,

I suggested in a previous post that you first do a array fill with the
data and then only pass that into the creation of the ArrayServer, the
speed improvement I get on my side is 10+ times faster than trying to
insert into the ArrayServer with Append/FieldPut.

What I would do first is to create the array large enough to hold all
the records:
Sorry if I got some of the syntax wrong, some time since I actually
worked in VO...

// Create hopefully large enough array to hold alll records
aRecs := ArrayNew(10000)
nPos := 0 // Current position in array
nFCount := oDbf:FCount
WHILE !oDbf:Eof
  nPos++
  aRec := ArrayNew(nFCount) // Array to hold values of dbf columns
  FOR i := 1 UPTO nFCount
    aRec[i] := oDbf:FieldGet(i)
  NEXT
  IF nPos > ALen(aRecs) // The array is not large enough to hold the
dbf
    // Add say 100 more items to array
    ASize(aRecs, nPos + 100)
  ENDIF
  aRecs[nPos] := aRec // Insert record array into records array
  oDbf:Skip()
ENDDO
ASize(aRecs, nPos)
aServer := bArrayServer{aStruct, aRecs, ....}

HTH,

Johan Nel
Vulcan VIP
Durban, South Africa.

On Jul 13, 11:13 am, Martin <s...@spam.spam> wrote:
> Because the data came from more than one DBF and wanted to be sortable
> of fields which were only existing during display.
>
> On 12/07/2012 17:42, Stephen Quinn wrote:
>
>
>
>
>
>
>
> > Martin
>
> >> I had a 2000 row 35 column array server and the program would used 3MB
>
> > I'd be asking why you need 2000 rows in an arrayserver.
>
> > CYA
> > Steve

[toc] | [prev] | [next] | [standalone]


#3767

FromMartin <spam@spam.spam>
Date2012-07-13 15:27 +0100
Message-ID<dfWLr.815494$pD7.258944@fx21.am4>
In reply to#3765
I am moving toward temporary files, but we are still getting screen 
blanking in 2.8 not in 2.7

On 13/07/2012 11:40, Johan Nel wrote:
> Martin,
>
> I suggested in a previous post that you first do a array fill with the
> data and then only pass that into the creation of the ArrayServer, the
> speed improvement I get on my side is 10+ times faster than trying to
> insert into the ArrayServer with Append/FieldPut.
>
> What I would do first is to create the array large enough to hold all
> the records:
> Sorry if I got some of the syntax wrong, some time since I actually
> worked in VO...
>
> // Create hopefully large enough array to hold alll records
> aRecs := ArrayNew(10000)
> nPos := 0 // Current position in array
> nFCount := oDbf:FCount
> WHILE !oDbf:Eof
>    nPos++
>    aRec := ArrayNew(nFCount) // Array to hold values of dbf columns
>    FOR i := 1 UPTO nFCount
>      aRec[i] := oDbf:FieldGet(i)
>    NEXT
>    IF nPos > ALen(aRecs) // The array is not large enough to hold the
> dbf
>      // Add say 100 more items to array
>      ASize(aRecs, nPos + 100)
>    ENDIF
>    aRecs[nPos] := aRec // Insert record array into records array
>    oDbf:Skip()
> ENDDO
> ASize(aRecs, nPos)
> aServer := bArrayServer{aStruct, aRecs, ....}
>
> HTH,
>
> Johan Nel
> Vulcan VIP
> Durban, South Africa.
>
> On Jul 13, 11:13 am, Martin <s...@spam.spam> wrote:
>> Because the data came from more than one DBF and wanted to be sortable
>> of fields which were only existing during display.
>>
>> On 12/07/2012 17:42, Stephen Quinn wrote:
>>
>>
>>
>>
>>
>>
>>
>>> Martin
>>
>>>> I had a 2000 row 35 column array server and the program would used 3MB
>>
>>> I'd be asking why you need 2000 rows in an arrayserver.
>>
>>> CYA
>>> Steve
>

[toc] | [prev] | [next] | [standalone]


#3774

From"richard.townsendrose" <richard.townsendrose@gmail.com>
Date2012-07-15 04:37 -0700
Message-ID<d6ed3a57-7ba8-4dbf-acac-08006de4e8fd@googlegroups.com>
In reply to#3767
Martin

Try using the Applicationexec(execwhileevent) function within the load loop.

It will of course necessarily slow the operation down.

richard

[toc] | [prev] | [next] | [standalone]


#3916

FromMathias <mathias.hakansson@consultec.se>
Date2012-08-08 22:57 -0700
Message-ID<3db709ee-5e40-4838-a73c-700ce291e44b@googlegroups.com>
In reply to#3755
Martin,

What exactly is taking time,

is it the filling of the array?

Would you say that the time increases exponentially when the amount of data increases?

In that case it could be dynamic memory handling by the gc that is slow.

The remedy for this is to move the data into static memory instead.

/Mathias

Den torsdagen den 12:e juli 2012 kl. 17:51:23 UTC+2 skrev Martin:
> Still not sure if it is, but we managed to get similar issues using 
> 
> large array servers.
> 
> 
> 
> I had a 2000 row 35 column array server and the program would used 3MB 
> 
> or similar and after a while the screen updates would take ages.
> 
> 
> 
> We do use CollectForced() as well.
> 
> 
> 
> 2.7 appears to be fine 2.8 gets blank screens, they populate a while 
> 
> (minutes) later.
> 
> 
> 
> bArrayServer large loads appear to set it off
> 
> 
> 
> I will be fixing this issue with more temporary files.
> 
> 
> 
> Martin

[toc] | [prev] | [next] | [standalone]


#3927

From"Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it>
Date2012-08-10 10:51 +0200
Message-ID<k02i38$5ka$1@dont-email.me>
In reply to#3755
VO 2.8 seems to be much more safe. If there is not enough it makes collect 
forced on its own what consumes time. It is important to give the program 
enough main memory with SetMaxDynSize and DynSize. Also it may be useful to 
delete Collectforced in the program.

Arne


"Martin" <spam@spam.spam> schrieb im Newsbeitrag 
news:MnCLr.637736$8G5.132795@fx12.am4...
> Still not sure if it is, but we managed to get similar issues using large 
> array servers.
>
> I had a 2000 row 35 column array server and the program would used 3MB or 
> similar and after a while the screen updates would take ages.
>
> We do use CollectForced() as well.
>
> 2.7 appears to be fine 2.8 gets blank screens, they populate a while 
> (minutes) later.
>
> bArrayServer large loads appear to set it off
>
> I will be fixing this issue with more temporary files.
>
> Martin 

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web