You could check whether the network itself is set up efficiently: for instance, 100 Mbps rather than 10 Mbps; switches instead of hubs - or at least a few central switches, which then connect hubs.

Disable your antivirus temporarily, to see whether that one causes problems. Norton is often linked to a slowdown in VFP.

You may want to see whether the views are optimized. For instance, appropriate indices are defined. Many developers will agree with me that it is usually better NOT to have an index on deleted() (many others won't), but you may do some tests to compare both.

I suggest you post the SQL statements for particular views, so that we can help with more specific suggestions.

If it is for a report or another R/O usage, use SELECT - SQL commands instead of views. Separating a query into several steps (adding one table at a time) will sometimes produce a dramatic speed improvement.

>I inheritted an application that is installed on a computer - desktop or server - doesn't matter. That folder is then shared with Windows and multiple clients connect to it - up to 15 but usually only 3-4. The executable is about 11 megabytes and the foxpro dll's are in that folder as well. When the tables start getting over 2-3 megs each, processes in the application start to run REALLY slowly. The worst is when a view is in a dataenvironment that opens a few tables joined together.
>
>What is the best way to deal with this besides re-writing the application to run from SQL server? Any ideas?
>
>Randy Wessels