RE: VFP6: Rushmore/Network Performance

Author: Russell, Stephen

Posted: 2002-09-13 at 15:22:54

Oh you wanted it faster? Well for an NOMINAL fee I can fix that by

tomorrow. I just have to push that turbo button on your server in. hehehehe

Stephen Russell

Developer - Clinical Research Shared Resource

St. Jude Children's Research Hospital

Mail Stop 504

332 North Lauderdale St.

Memphis, TN 38105

(901) 495-3807 - Office

(901) 246-0159 - Cell

-----Original Message-----

From: Crooks, David L. [mailto:croodl@ispec.com]

Sent: Friday, September 13, 2002 10:13 AM

To: Multiple recipients of ProFox

Subject: RE: VFP6: Rushmore/Network Performance

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

http://leafe.com/

http://foxcentral.net

©2002 Russell, Stephen