Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scan and Update with 2 cursors
Message
 
 
To
14/08/2008 16:17:07
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01338981
Message ID:
01338991
Views:
13
I thought I answered you (about UPDATE FROM), but then I found I actually didn't. Perhaps I didn't post my reply when I got distracted.

Anyway, can you post some of your code here to see exactly what's going on? In VFP8 I would use Rich's approach.

>Hi All,
>
>I have a program, where I collect info into 1 cursor (fstcursor), then use that cursor to update a different cursor (mncursor). At the moment, I have to do a scan of fstcursor, and update mncursor within that scan. With 100,000+ records, this takes a while. Is there a better way to do this?
>
>I have a lot of these updates in the program, plus some fors. At the moment, the program takes well over 16 minutes to run (still has not finished this run) with 100,000 to 110,000 records.
>
>I thought maybe getting rid of scans might help, but I wanted to ask you, UT members, first. :)
>
>Thanks,
>Beth
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform