>Hi everyone,
>
>I have developped an application running VFP5 using the VFExpress framework 5.01 . The application itself is running fine everywhere except for this one customer.
>This customer is using my app in 4 different buildings. The main building (A) is equipped with a 10/100 LAN and all it's users have no problem with the app except when a or more users from any of the other 3 buildings (B-C-D) is (are) concurrent.

Pierre, I am using VFE 5.0.

You mostly spoke of delays with lookups. I don't have anything to add to the other suggestions in these cases.

I found that updates were unacceptably slow (3-30 seconds) in some cases. This was on a 10/100-base T LAN. My experiences was that when things got slow, that reliability also suffered with more update failures.

I have rewritten two forms to use custom update code. Everything is standard VFE methods while the data is being entered. I rewrote the form and biz object save methods to use pure TABLEUPDATE commands on each of the tables being changed with appropriate checks and ROLLBACK if necessary. About 20-30 lines of code. Update time went down to less than 500 milliseconds in almost all cases. There have been fewer failures too.

Oh, yes. The really big improvements (100 to 1) were also due to eliminating some LOCATE commands which were really slow when operating on buffered data.

If this sounds interesting I can tell you more details.

Peter Robinson


P.S.
I took a little French in High School, "Pierre" was my nickname...