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?

Thanks,

Jim Condon