topic-37435

Posts: 50

Joined: Tue May 16, 2017 12:19 PM

Tdatabase performance issue
Posted: Wed Jul 10, 2019 07:11 PM

Should there be any performance overhead when using Tdatabase as opposed USE DBF command

As reading a through a DBF of approx 9k records is about 2-3 seconds slower when opened using Tdatabase than when
it is opened by the USE command.

There are no filters or relations set,DBF uses one NTX

Currently just running on a stand alone PC

Thanks
Peter

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Tdatabase performance issue
Posted: Thu Jul 11, 2019 04:28 AM

Should there be any performance overhead when using Tdatabase as opposed USE DBF command

Yes.

Regards

G. N. Rao.

Hyderabad, India

Posts: 1096

Joined: Fri Oct 28, 2005 02:27 AM

Re: Tdatabase performance issue
Posted: Thu Jul 11, 2019 05:02 AM

Peter,
You can try :SetBuffer(.f.) to see whether that could help improve the speed a bit

FWH 11.08/FWH 19.12

BCC5.82/BCC7.3

xHarbour/Harbour

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Tdatabase performance issue
Posted: Thu Jul 11, 2019 05:11 AM

hua wrote:Peter,
You can try :SetBuffer(.f.) to see whether that could help improve the speed a bit

Yes, it does improve the speed. Same as reading DBF directly.

Regards

G. N. Rao.

Hyderabad, India

Posts: 50

Joined: Tue May 16, 2017 12:19 PM

Re: Tdatabase performance issue
Posted: Thu Jul 11, 2019 09:10 AM

Thanks both that did it
Regards
Peter

FiveTech Support Forums