Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stopping Re-ordering of Index File During Update
Message
From
19/09/2003 09:52:53
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
18/09/2003 19:57:15
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00830509
Message ID:
00830645
Views:
35
Hi Bob

Do you mean mean something like this?
SELECT bigtable
SEEK particularvalue
DO WHILE FOUND()
  REPLACE numericfield WITH newvalue IN bigtable
  SEEK particularvalue
ENDDO
or this...
SELECT bigtable
SET ORDER TO 0
REPLACE numericfield with newvalue FOR numericfield = particularvalue IN bigtaqble
Since you have an index on numericfield, Rushmore Optimization should kick in. It won't be as fast as the seek, but it should be close since there're fewer lines of code than the seek method.

>sergey,
>
>I would like to follow your suggestion but the table in quetsion is very large and I have a program that is seeking groups of records indexed by a particular value in the index field - if i do a search in physical order rather than in index order the process will take 10 times longer, which is why I was looking for a means to stop the table index being updated until the whole process is finished.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform