Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INSERT not as maintainable?
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01140411
Message ID:
01140530
Vues:
15
>APPEND BLANK updates all the index tags with blank values. Your replace then updates them *again*.
>
>INSERT only writes the single value.
>
>In a loop, the performance difference can be dramatic.
>
>Dan

I had a longer thread on a similar topic going on. Basically, my question is what is better

insert (field list) values (list)

or
scatter memvar
release few vars
insert from memvar

John Koziol said, that the second is going be faster. I ran lots of tests in last couple of days and though they are not conclusive, it looks like the performance of my "enhanced" program is worse than orginal procedural code, that has several obvious flaws.

May be the problem is in using class properties in insert command? I just put this.cUserID in several inserts. I'm thinking, I need a variable instead for better performance.

Still, something else is going on which I can not yet identify.
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