"Based on my experience I believe this is a myth. We have hundreds of
programs doing single I/O operations using SQL and I have yet to see
any real problem. You might do a test and have a few milliseconds
slower but in a real world environment does that really matter?"
I've tested it with a uniquely-keyed DDS-described PF, and I say fact, not myth. An OPEN/CHAIN/CLOSE=.001 seconds, while a SELECT INTO=.5 seconds. To me, that matters.
This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact