Posted by Doug on 03/06/06 05:55

Hmmmm.

Perhaps I'm missing something. Rather then use recursion, or use a
loop, you are suggesting that we somehow load all possible instances
into parameters, then pass them as parameters.
Option 1 requires simple memory manipulation without any accessing of
the disk. My experience has indicated that we are ALWAYS better off to
crunch in memory without resorting to accessing the disk drive.
For option 2,
I'd be very curious as to the logic where an index could be used to
prevent a complete table scan would not be required of FOOBAR. In
other words, I can't imagine this being nearly as fast as a simple join
against a temp table.
For option 3.
Ok. I'll bite. How do you load all of those fine data values into
those fine parameters without loops and without recursion? And, any
suggestions as to how you would go about dealing with, say, 10,000
iterations, or at least, the possiblity of 10,000 iterations?
Would you REALLY create 10,000 variables, or would you just give up,
and use a loop or recursion?
I'd be very interested in learning of the application where your
solution 3 was actually used.
Thanks in advance,
-doug

[Back to original message]