VFP Clos Data Alll slow on network

[stanbe]

I have a VFP 3.0 application running on network. When running application from workstation saving records to the server takes about 15 seconds. Running the same program from server takes less than 2 seconds. Also, running with data on local workstation takes less than 2 seconds.

Programs are on local computer and database is on server
Turning off anti-virus did not help.
I used trace window to find slow command. The "Close Data All" takes about 8 seconds to execute.
Thanks for any help.

 

[EzLogic]

What type of NIC speed you have?
Also, what type of cabling you have?
What type of switch you have?

I would do a test and do a cross-over cable form station to server direct and see. If that goes fast, then, it has something to do with Router/Switch.

Ali Koumaiha
Wireless Toyz
Farmington Hills, Michigan

 

[stanbe]

Nics are 10/100
wire is cat6e
Switches are 10/100 eithernet
I takes about 40 seconds to transfer 150MB of data across the network.
I tried from various computers running through different switches on the network with the same slow performance.
I also tried moving the data from server to a different computer with the same slow performance for Clos Data All command in Foxpro.
I don't think that it is a network problem. Everything else on the network is fine (printing to print servers, internet access). Other computer accessing the same data via ODBC has no speed issue. I think that it is a Foxpro issue.

 

[stanbe]

I realize that a LAN would be slower. But this is extremely slow. At one time the speed was much better with barely a difference between the computer with data on local drive and a workstation. I tried changing the code to find out what was taking so long:

Sele 1
Use

Sele 2
Use
etc
Instead of Clos Data All
I ran it and it still slowed down. When it gets to a temporary work tables that I create to print reports it takes a long time to close even though it is not a large table. The largest table that I have is 320,000 records and opens and closes without the slightest delay. In the debug window everything runs fine but when it gets to the temporary work table it takes 6 seconds for the Use command to close the table. I tried changing the program by adding a table to the database container and leaving the table there permanently (instead of creating the table new every time). Still same slow results.
Any suggestions would be much appreciated.

 

[stanbe]

Mike
Sorry for the long delay in my response. We were closed between Xmas & New Year so I did not have a chance to test. Yes I am a little embarrassed to admit it was the anti-virus. I had previously tried turning off anti-virus but it did not help. After putting VFP path in anti-virus to not be scanned, speed increased.
The reason for selecting and closing each work area separately was to an attempt to find if there was one table in particular that was causing the problem.
Thanks for your help
Stan Berrie
Island Park, NY