>>>> I need some input on having a VFP 5.0 application that is going to be used accross the US by my office on a number of LANS, some that will have users connected over 56K dedicated lines. I know that using VFP 5 will involve some increased overhead as apposed to the prior version of Foxpro this was written in (FP 2.x DOS/Windows).
>>>>
>>>>Can anyone offer input as to how I can optimized the application, as to squeeze as much speed out of it as possible. I am locked in (maybe even held prisoner..) to the existing database design (very Un-normalized).
>>>
>>>Tony,
>>>
>>>Ah.. someone from the other Vancouver. Your last post went through.
>>>
>>>If your EXE is on the local PC, your app shouldn't run slower than the dos version of Foxpro in the same circumstances. (Someone jump in if I am wrong here).
>>
>>You are somehow. The interface is much slower in VFP than DOS.
>>
>
>Paul,
>
>Yes, I should have qualified that statement. The forms will be much slower, but the data access (SQL) should not be.

This is why I said "somehow". :) You're right. Unfortunately, it's much more easy to see the slow parts... :)

Vlad