>Hi All:
> I have a VFP application that uses SQL 7.0 as a backend. The coding is plain sql pass through statements with no record set. The issue is that the VFP application runs very slow. I could take a 30 sec. to load a form or just to starts the application. The application does runs faster on Win 2000 compare to Win 95. However, changing the OS is not an option. How can I be able to increase the speed of this application without installing Win 2000 on 20 users. Is there a third party ODBC software package that I should install or should I install Certix what should I be doing? At this I am in process of rewritting some the sql statements hoping to increase the performance.
>
>Thanks for all your ideas

Some of the first things to look at is how many rows are retrieved vs. how many rows does the user need to start working. Try to limit the number of rows retrieved for the main tables that the forms work with, and for things like data entry screens you could only bring back lookup tables for things like comboboxes or validation, leaving an option to do a search in case the user needs to modify existing records.

Also on the server side you can speed things up by using stored procedures, sending SQL that can be optimized and a few other things.

Are you loading the contents of transaction tables at form startup? Are you limiting the number of rows with a WHERE clause?

Just a few things to look at, and also read Chapter 19 in the VFP docs: "Designing Client/Server Applications".