FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Program very slow when runing on LAN
Posts: 365
Joined: Sat Oct 08, 2005 07:59 PM
Program very slow when runing on LAN
Posted: Thu Jul 26, 2007 02:37 PM

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

Posts: 883
Joined: Tue Oct 11, 2005 11:57 AM
Program very slow when runing on LAN
Posted: Thu Jul 26, 2007 02:51 PM

My answer on the spanish forum..

;-)

;-) Ji,ji,ji... buena la cosa... "all you need is code"

http://www.xdata.cl - Desarrollo Inteligente
----------
Asus TUF F15, 32GB Ram, 2 * 1 TB NVME M.2, GTX 1650
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Program very slow when runing on LAN
Posted: Thu Jul 26, 2007 07:50 PM

Rafael,

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

regards, saludos

Antonio Linares
www.fivetechsoft.com

Continue the discussion