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
--
Geek House Productions, Ltd.
Providing Unix & Internet Contracting and Consulting,
QA Testing, Technical Documentation, Systems Design & Implementation,
General Programming, E-commerce, Web & Mail Services since 1998
Phone: 604-435-1205
Email: djw(a)reactor-core.org
Webpage:
http://reactor-core.org
Address: 2459 E 41st Ave, Vancouver, BC V5R2W2