>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