Program very slow when runing on LAN

[Rafael Clemente]

I am using FWH 2.6 / Harbour to build an application whose main window is, basically, a TxBrowse() which shows the Customer.dbf table. This table is only about 4000 register long. I can apply a simple SET FILTER TO to restrict the number of registers shown. (I know that I can use Set Scope, but for other easons I have to stick to SET FILTER)

My vevelopment system includes two PCs connected in LAN at 100 Mb. Customer.dbf is located in one PC but hasto be accessed from both. Each PC has its own copy ot the excutable program. As you can see, a rather simple, conventional setup.

And now, my question: When I apply a filter from the main PC (the one containing the tables), te reaction is instantaneous; however, when I do it from the othe PC, is crawls v-e-e-e-ry slowly: Up to 5 seconds or more to filter only 4000 records. I remember a similar application developped years ago in DOS/Clipper that was equally fast no mater from which PC it was executed.

Obviously, I am missing somethig, but what? Some envireonment variable? Some SET in my program? Maybe to use some special swicth to compile the program?

I would appreciate any hits or suggestions. Thanks

Rafael

[Adolfo]

My answer on the spanish forum..

[Antonio Linares]

Rafael,

SET FILTER is very slow. Better use a temporary index built with a condition