>We have an in-house app that runs exponentially slower when two or more users access the data on our server. We've read all of the posts.. tried most of the solutions and we're still banging our heads against a wall. Here's what we got..
>
>The app has 10+ tables that have multiple relationships.. three forms are displayed at all times, each form has approx 20 controls, of which 3 to 4 are comboboxes and no grids. No views are being used (simple USE, SET RELATION TO, SEEKs etc).. we've played with disabling Norton Antivirus etc.. We've run the exe from each workstation as well as from the server with no success (speed wise).. we've tried placing all temporary files locally via config.fpw files.. our primary concern at the moment is speeding up the initial load and subsequent searches..
>
>Currently a user can load the exe and have all three forms up with data in about 11 seconds.. each find after that takes about 3 seconds (to find and refresh 3 forms).. if a second user comes in.. the 3 forms take approx 38 seconds to load.. and each find takes 31 seconds.. the two machines are pretty much identical.. same connection speed, same cpu, same memory.. extremely close on what's been installed, etc.
>
>Currently we have a license that allows two users to terminal service into the server and run the app.. this works fine..The entire system is currently being re-written in .NET but we need a short term speed gain to allow more users in the system while it is being overhauled. Therefore a major rewrite of the current VFP system is out of the question. Any ideas?
>
>-- Len

When everything fails check the basics. State of the indexes, memory availability, network. You mentioned migration to .NET. Is it running concurrently? .NET absorbs a lot of resources.
Are you using SQL Server or DBF's. If so, free tables or do they belong to a DBC?