Author: Crooks, David L.
Posted: 2002-09-13 at 11:12:53
I thought the SET OPTIMIZE OFF was for consultants to use until the users
complain that the app is too slow. Then the consultant can charge some more
them to take out the commands.
-----Original Message-----
From: Ed Leafe [mailto:ed@leafe.com]
Sent: Friday, September 13, 2002 10:46 AM
To: Multiple recipients of ProFox
Subject: Re: VFP6: Rushmore/Network Performance
On Friday, September 13, 2002, at 10:03 AM, Chuck Urwiler wrote:
> Just ideas from the top of my head. I've never seen a reason to turn
> it off in my experience.
The reason given for providing SET OPTIMIZE OFF is for dynamically
changing data, where your index cache might be out of date. Turning off
Rushmore forces VFP to look at the table itself, not a cached copy of
an index.
___/
/
__/
/
____/
Ed Leafe