>>To answer the first few questions...
>>
>>Most users have 14.4 or 28.8 Modems, VFP 5.0 is not currently an option, nor is running the app locally on the field rep PC.
>>
>>TIA,
>>
>>John
>
>1.) Are U C/S? What is your data engine? If U are not C/S then transmitting entire data sets over the wire is not a good thing. Check this forum for discussion on C/S and other sites like Inquiry.Com.
The App is a Native VFP app, that shares tables with a legacy Fox2.6 DOS app. C/S isn't really an option at this time.
>2.) Install EXEs locally on remote PCs. This will help performance. If U are worried about keeping version in sync; setup a small routine in the startup program to verify the current version...
That was my suggestion, but the client says No!
>3.) Can any data files be setup as free tables on the local PCs? Data files for validation for example.
Possibly, I will check for this!
>4.) Are Ur SQL statements optimized. ie; Do all of your tables have the proper indices setup?
Yes.
>5.) Are U using pageframes? If so, are the optimized? There is a good set of discussion items on this formum related to optimizing pageframes.
Yes, I believe them to be optimized, but can't hurt to re-check them!
>6.) Is there any other stuff in your forms that are slowing U down. Create a test form with just the grid and do some bench marking so U know where U stand. This might be the first thing I would try. It may give U justification to go to a Client/Server environment.
Ran Benchmarks and was receiving 2-3 second delays, on a one column grid populated by an SQL Cursor loaded during form init.
>Well this is the third submission; hopefully it will get through... It must be snowing somewhere
>Let me know if any of this stuff helped...
>Steve
Thanks for the advice/suggestions. I'll keep trying!
John
John Adams
John T. Adams
Software Consulting Services