>>>> 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.
Evan,
Being the way the data is structured (Many tables versus a more relational design), this is where I think one of the MAJOR hangups will and is occuring...

Plus the fact that in my opinion, this is just a porting of the existing code from FP 2.x to VFP, will make it a very hard app to maintain... There was no real taking advantage of the features of VFP, besides the fact that it runs under Win 95...

Thanx!

Tony Miller
Vancouver,Wa