Page 1 of 1

Tdatabase performance issue

Posted: Wed Jul 10, 2019 7:11 pm
by reds
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

Re: Tdatabase performance issue

Posted: Thu Jul 11, 2019 4:28 am
by nageswaragunupudi
Should there be any performance overhead when using Tdatabase as opposed USE DBF command
Yes.

Re: Tdatabase performance issue

Posted: Thu Jul 11, 2019 5:02 am
by hua
Peter,
You can try :SetBuffer(.f.) to see whether that could help improve the speed a bit

Re: Tdatabase performance issue

Posted: Thu Jul 11, 2019 5:11 am
by nageswaragunupudi
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.

Re: Tdatabase performance issue

Posted: Thu Jul 11, 2019 9:10 am
by reds
Thanks both that did it
Regards
Peter