Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow query
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00120887
Message ID:
00121221
Views:
18
>>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.

Hi Jim,

Yes, the database is the same for both. Set settings are SET DELETED ON and SET EXACT OFF in the main.prg. Actually the RAM is more and the HD space is larger on the user's machines than on my development machine. I've tried only running the fox app with nothing else on the users machine with the same results.

I did upgrade my development machine to vfp5.0a about a month ago.

John.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform