Page 1 of 3
xbrowse too slow
Posted: Thu Sep 05, 2019 2:59 pm
by Silvio.Falconi
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 ?
Re: xbrowse too slow
Posted: Tue Sep 17, 2019 5:41 pm
by James Bott
Turn off buffering.
oDBF:lBuffer:=.f.
Re: xbrowse too slow
Posted: Tue Sep 17, 2019 6:50 pm
by Silvio.Falconi
it'a tdata or tdatabase set ?
Re: xbrowse too slow
Posted: Tue Sep 17, 2019 7:14 pm
by James Bott
Works with both.
Re: xbrowse too slow
Posted: Tue Sep 17, 2019 7:58 pm
by Silvio.Falconi
not run good I see all same records
where I must insert it ?
Re: xbrowse too slow
Posted: Tue Sep 17, 2019 9:19 pm
by James Bott
Anywhere before the browse.
I don't know what you mean by "I see all the same records." Are you using a filter?
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 6:33 am
by Silvio.Falconi
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
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 7:07 am
by James Bott
one record * 6135 records
I don't understand. Do you mean you see the same record repeated 6135 times?
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 7:11 am
by Silvio.Falconi
I put it after I open the archive
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 7:19 am
by James Bott
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.
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 7:20 am
by Silvio.Falconi
oLotto:= TDatabase():Open( , cDir+"Lotto", "DBFCDX", .T. )
oLotto:setorder(nOrder)
oLotto:gotop()
oLotto:lbuffer:=.f.
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 7:26 am
by James Bott
Did you do:
oBrw:setoDbf(oLotto)
Without that the database doesn't skip
to the next record.
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 7:31 am
by Silvio.Falconi
nages sad me to erase this command
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 7:35 am
by James Bott
I don't know why. Put it back in and try it.
Re: xbrowse too slow
Posted: Wed Sep 18, 2019 8:06 am
by Silvio.Falconi
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 )