Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Exact and deleted recs - did everybody know this but me?
Message
De
24/07/2006 14:33:40
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01139176
Message ID:
01139352
Vues:
15
>>If I were writing this thing from scratch, I'd do as you suggest, but unfortunately, with only God knows how many lines of code existing in this app, I don't have that luxury. Do you think it's safe to count on tricking VFP the way I'm doing it?
>
>No, it's not safe. Your results are not reliable.

You know... I was afraid you'd say that. ;)

For the record though, by 'not reliable', do you mean from run to run, or for future reference. So far, it's been completely reliable in my testing, but I don't know what MS might do later to screw it up for me and so far, I'm at a loss to find another way to speed this thing up. The way it is now, it's just waaaayyy too slow. Doing what I did took it down to sub 1 second. Well, I'm going to keep rummaging around for an answer, but in the meantime, I may have to treat this as a temporary fix.

>
>I explained it in another message (to Mike Yearwood) that I'm trying to find a way around an SQL call taking too long, so I need to see deleted records in the returned cursor with their flags still set in order to speed things up.
>>
>>I can speed things up from anywhere from 10 to 20 seconds down to sub 1 second if I can use this trick. But if this behaviour is likely to change in order to standardise along ANSI lines, then I need to find another way to do it, and nothing else I've tried has really worked well so far.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform