< SNIP >
>For 50000 records the results are:
>Method 1: 0.423
>Method 2: 1.556
>Method 3: 0.904
>Method 4: 0.531
>
>For 100000 records the results are:
>Method 1: 0.800
>Method 2: 3.707
>Method 3: 1.803
>Method 4: 2.277
>
>For 200000 records the results are:
>Method 1: 2.094
>Method 2: 100.774 && Very strange
>Method 3: 6.592
>Method 4: 4.155
SET TALK OFF set safety off
*For 50000 records the results are:
*Method 1: 0.271
*Method 2: 0.491
*Method 3: 0.471
*Method 4: 0.321
*For 100000 records the results are:
*Method 1: 0.511
*Method 2: 1.302
*Method 3: 0.961
*Method 4: 0.571
*For 200000 records the results are:
*Method 1: 0.942
*Method 2: 5.738
*Method 3: 1.932
*Method 4: 1.111
*For less than 10,000 the result is:
*Method 1: 0.000 *
*Method 2: 0.130
*Method 3: 0.080
*Method 4: 0.090
And the winner is : Meth1 - Dele All, Ind Unique, Recall All
Runner up : Meth4 - Sele into Cur, Append
Why is method4 slower than Scan in Scan or Do While?
Edgar L. Bolton, B.S. B.B.A.