Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Scan and Update with 2 cursors
Message
De
14/08/2008 16:35:32
 
 
À
14/08/2008 16:17:07
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Divers
Thread ID:
01338981
Message ID:
01338991
Vues:
11
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform