On Tue, Dec 10, 2002 at 09:15:14AM -0500, Poor, Edmund W wrote:
Any savings you predict are only guesses. I don't think we can predict the performance benefits of cutting down the *number* of separate queries.
If you think otherwise, what is your basis?
My basis is that each query requires a separate parsing, planning, optimization, and execution stage. Although execution may happen fast, cutting the other stages out of the loop can provide dramatic speed improvements. Amortized over thousands of queries, the effect is really dramatic.
My basis is years of experience applying Chuck Moores FORTH philosophy to factor, refine, and do ONLY what is necessary, and no more.
There is a certain required amount of complexity for this project. But we should not let it expand beyond that. Complexity begets complexity in an unholy upward spiral.
In this design stage we are finding out what is needed. Later on we can work on simplifying, etc.
For inspirational reading, here is an essential essay from Mr. Moores protege, Jeff Fox:
http://ultratechnology.com/forth.htm
Jonathan