very slow also with array

[Silvio.Falconi]

I changed the view of the extractions to create statistics and before I used the archive directly now I'm going to create an array according to certain settings created by the end user. I scroll through the extraction dates with a scrollbar and xbrowse updates the extractions automatically also inserting the statistics made. the problem that I can see is that the time between one extraction and the other is very slow that is I have to wait those 5/8 seconds to wait for xbrowse to change configuration sometimes the time exceeds 15/18 seconds and I don't understand why it should take less than two seconds.



Any solution pls?

[Otto]

Hello Silvio,
I think you need to implement time measurements in the individual steps so that you can see where in which section of the source code the program is slow.
You can link xbrowse and also implement a time measurement in the methods there.
Best regards,
Otto

[Silvio.Falconi]

Hello Silvio,
I think you need to implement time measurements in the individual steps so that you can see where in which section of the source code the program is slow.
You can link xbrowse and also implement a time measurement in the methods there.
Best regards,
Otto

Otto,
I make this

@ 16, 5 SCROLLBAR oScrollDbf HORIZONTAL SIZE 425,10 PIXEL OF oDlg ;
RANGE 1,ntotal_records ;
ON DOWN (nSec := SECONDS(), oDbf:Skip(), IIf( oDbf:EoF(), oDbf:GoBottom(),),;
Refresh_Say(oSay,oDbf) ,;
Refresh_data1(.....),;
Refresh_data2(....),Msginfo(SECONDS() - nSec)) ;
ON UP (nSec := SECONDS(), oDbf:Skip( -1 ) ,;
Refresh_Say(oSay,oDbf) ,;
Refresh_data1(......),;
Refresh_data2(......),Msginfo(SECONDS() - nSec))


data1 need for refresh oBrw1, data2 for obrw2

Now I change the archive I use last 200 records of 10526 - I tried to use a statistics archive , but I made a test

Maybe to make a good statistic you have to use 2000 records like I used in the old Dos program, but some use 500/800

It give 0.92 /0.96/ ,1.06

If I use entire archive ( archive of lotto from 1871 to 2024 - 10526 records) I have

5.50/5.60/5.62/5.67