>I finally upgraded my development to VFP9 SP2 from VFP8. Added in lots of coding to take advantage of new reporting features, etc. All worked well on my fast single machine.
>But when put on a network with multiple users, the data retrieval was 3-5 times as slow or 20% of the previous speed.
>I've built a small program that just does one select statement from a 100,000 record database - VFP8 - perhaps 1/2 second as expected. VFP9 - 5 seconds.
>
>What could I be doing wrong?

Make sure that CPDBF() matches CPCURRENT(). Compare SYS(3054) output for the query between VFP8 and VFP9.