FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour xbrowse too slow
Silvio.Falconi
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
xbrowse too slow
Posted: Thu Sep 05, 2019 02:59 PM
on an archive lotto.dbf
I'm using tdatabase

I have 57 field
I have 6130 records for 733KB
I index on dts(data)+concorso



and xbrowse is too too slow

do you have try with big dbf ?

I use Multiheader perhaps it is slow ?
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
James Bott
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: xbrowse too slow
Posted: Tue Sep 17, 2019 05:41 PM

Turn off buffering.

oDBF:lBuffer:=.f.

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Silvio.Falconi
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Re: xbrowse too slow
Posted: Tue Sep 17, 2019 06:50 PM

it'a tdata or tdatabase set ?

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
James Bott
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: xbrowse too slow
Posted: Tue Sep 17, 2019 07:14 PM

Works with both.

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Silvio.Falconi
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Re: xbrowse too slow
Posted: Tue Sep 17, 2019 07:58 PM

not run good I see all same records
where I must insert it ?

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
James Bott
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: xbrowse too slow
Posted: Tue Sep 17, 2019 09:19 PM

Anywhere before the browse.

I don't know what you mean by "I see all the same records." Are you using a filter?

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Silvio.Falconi
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 06:33 AM

no I see the same records I have 6135 record but if I set that command I see only one record * 6135 records
Imust see perhaps I insert it after the xbrowse

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
James Bott
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 07:07 AM
one record * 6135 records


I don't understand. Do you mean you see the same record repeated 6135 times?
FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Silvio.Falconi
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 07:11 AM




I put it after I open the archive
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
James Bott
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 07:19 AM

Are you loading the database into an array or something?

Turning off the buffer should have no effect on the display other than speeding it up.

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Silvio.Falconi
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 07:20 AM

oLotto:= TDatabase():Open( , cDir+"Lotto", "DBFCDX", .T. )
oLotto:setorder(nOrder)
oLotto:gotop()
oLotto:lbuffer:=.f.

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
James Bott
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 07:26 AM

Did you do:

oBrw:setoDbf(oLotto)

Without that the database doesn't skip
to the next record.

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Silvio.Falconi
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 07:31 AM

nages sad me to erase this command

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
James Bott
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 07:35 AM

I don't know why. Put it back in and try it.

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Silvio.Falconi
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 08:06 AM

Application

Path and name: C:\Work\Prg\lotto\SuperLotto.Exe (32 bits)
Size: 8,185,856 bytes
Compiler version: Harbour 3.2.0dev (r1904111533)
FiveWin version: FWH 19.05
C compiler version: Borland/Embarcadero C++ 7.0 (32-bit)
Windows version: 6.2, Build 9200

Time from start: 0 hours 0 mins 24 secs
Error occurred at: 18-09-2019, 10:05:37
Error description: Error BASE/1004 Message not found: TXBROWSE:SETTODBF

Stack Calls

Called from: .\source\function\HARBOUR.PRG => _CLSSETERROR( 247 )
Called from: .\source\classes\XBROWSE.PRG => TXBROWSE:SETTODBF( 10879 )
Called from: source\PLotto.prg => ESTRATTI( 151 )

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
Static archive · New replies & topics via GitHub Discussions