xbrowse too slow

[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 ?

[James Bott]

Turn off buffering.

oDBF:lBuffer:=.f.

[Silvio.Falconi]

it'a tdata or tdatabase set ?

[James Bott]

Works with both.

[Silvio.Falconi]

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

[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?

[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

[James Bott]

one record * 6135 records

I don't understand. Do you mean you see the same record repeated 6135 times?

[Silvio.Falconi]

I put it after I open the archive

[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.

[Silvio.Falconi]

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

[James Bott]

Did you do:

oBrw:setoDbf(oLotto)

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

[Silvio.Falconi]

nages sad me to erase this command

[James Bott]

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

[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 )