>The users machines are creating the temp files on their local drives c:\windows\temp. What doesn't make any since to me (other than I don't know what the heck is going on here), is why the temp file is so big...It is acting like a badly constructed query, but I know this query works fine because it completes on my development machine in less than a second. Can you think of any other suggestions? Thanks.
>
John,

Are you both running against the same data? Is there a diffference between the ST DELETED or SET EXACT settings on the machines? Is the hardware, CPU and RAM, the same? What else is running on the production machines when the fox app does its query? The production machines may be hitting the windows swap file alot.