Tdatabase performance issue

[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

[nageswaragunupudi]

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

Yes.

[hua]

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

[nageswaragunupudi]

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.

[reds]

Thanks both that did it
Regards
Peter