Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #3755 > unrolled thread
| Started by | Martin <spam@spam.spam> |
|---|---|
| First post | 2012-07-12 16:51 +0100 |
| Last post | 2012-08-10 10:51 +0200 |
| Articles | 8 — 6 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2012-07-12 16:51 +0100 |
| Subject | Got 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]
| From | "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> |
|---|---|
| Date | 2012-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]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2012-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]
| From | Johan Nel <johan.nel@xsinet.co.za> |
|---|---|
| Date | 2012-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]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2012-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]
| From | "richard.townsendrose" <richard.townsendrose@gmail.com> |
|---|---|
| Date | 2012-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]
| From | Mathias <mathias.hakansson@consultec.se> |
|---|---|
| Date | 2012-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]
| From | "Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it> |
|---|---|
| Date | 2012-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