FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour very slow also with array
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
very slow also with array
Posted: Sat Oct 12, 2024 07:33 PM
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?
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: very slow also with array
Posted: Sun Oct 13, 2024 06:36 AM

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

Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Re: very slow also with array
Posted: Sun Oct 13, 2024 05:29 PM
Otto wrote: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
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

Continue the discussion