>Hi Nadya,
>
>>I just tried it. To replace value with 50000 records (the same value to the same value) it originally took 91 sec. and now it's 35 sec., with native RI is taking 51 sec. That's definitely a huge improvement.
>
>Well, that is nearly all for that approach: there are still a few ms hiding, but not enough to ferry out.
>But remember that I sent you this code cold: just visualizing the data flow for the RIDef-Table and some inspired line cutting. There is at least one lcTag undefined AFAIR... Not production quality yet ;-)
>
>Build a few test cases for other operations as well and keep me informed about the numbers. Also pls. check your company mail acount: don't worry, it is not a bill...
>
>regards
>
>thomas
I re-ran it again and now it takes 87 sec. for 50000 recs. Did I do something bad again? It's like 1 step forward and 2 backwards... :( And I hadn't yet tested everything in my test database.
I did a test with my TEST database first using yesterday's code. It took 13 sec. Then with today's code. It took 17 sec. I guess, I'm running in the wrong direction...
If it's not broken, fix it until it is.
My Blog