Make sure the table and indeces are all using the same code page.
>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer