xbrowse too slow

Silvio.Falconi · Post by **Silvio.Falconi** » Thu Sep 05, 2019 2: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 ?

James Bott · Post by **James Bott** » Tue Sep 17, 2019 5:41 pm

Turn off buffering.

oDBF:lBuffer:=.f.

Silvio.Falconi · Post by **Silvio.Falconi** » Tue Sep 17, 2019 6:50 pm

it'a tdata or tdatabase set ?

James Bott · Post by **James Bott** » Tue Sep 17, 2019 7:14 pm

Works with both.

Silvio.Falconi · Post by **Silvio.Falconi** » Tue Sep 17, 2019 7:58 pm

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

James Bott · Post by **James Bott** » Tue Sep 17, 2019 9: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?

Silvio.Falconi · Post by **Silvio.Falconi** » Wed Sep 18, 2019 6: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

James Bott · Post by **James Bott** » Wed Sep 18, 2019 7:07 am

one record * 6135 records

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

Silvio.Falconi · Post by **Silvio.Falconi** » Wed Sep 18, 2019 7:11 am

I put it after I open the archive

James Bott · Post by **James Bott** » Wed Sep 18, 2019 7: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.

Silvio.Falconi · Post by **Silvio.Falconi** » Wed Sep 18, 2019 7:20 am

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

James Bott · Post by **James Bott** » Wed Sep 18, 2019 7:26 am

Did you do:

oBrw:setoDbf(oLotto)

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

Silvio.Falconi · Post by **Silvio.Falconi** » Wed Sep 18, 2019 7:31 am

nages sad me to erase this command

James Bott · Post by **James Bott** » Wed Sep 18, 2019 7:35 am

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

Silvio.Falconi · Post by **Silvio.Falconi** » Wed Sep 18, 2019 8: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 )

FiveTech Software tech support forums

xbrowse too slow

xbrowse too slow

Re: xbrowse too slow

Re: xbrowse too slow

Re: xbrowse too slow

Re: xbrowse too slow

Re: xbrowse too slow

Re: xbrowse too slow

Re: xbrowse too slow

Re: xbrowse too slow

Re: xbrowse too slow

Re: xbrowse too slow

Re: xbrowse too slow

Re: xbrowse too slow

Re: xbrowse too slow

Re: xbrowse too slow