Are we talking a different network server? Could you be seeing a difference in network response time? Did you add any indices to the .cdx on your personal copy?
>I'm accessing a database that's actually being used by another program written in FoxPro. My access is read only, no writing is being done, but here's the fun part:- I made a copy of the database to my personal directory on the network to test with while I was programming...I made my SELECT statements, optimized the statements, and it pulled the data quickly...however, when I got done and pointed the program to use the actual database that is used company wide, suddenly all my optimization isn't doing any good...or something, because now a search for a single part number takes 10 seconds instead of 1. It was that much of a perfomance drop...has anyone had any kind of experience with this sort of thing? Any advice?
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place