× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



<Nathan>
In regard to the performance of SQL vs. RLA, perhaps the most relevant fact
is that the SQL Query Engine uses RLA under the covers.
</Nathan>

You missed the point in every direction!!!
Using RLA, the programmer is telling how the data should be retrieved. Using SQL (in an appropriate way) the programmer tells the query engine what data he/she wants to have/manipulate and the query engine makes the needed decisions how to do its best, based on the available indexes and some estimates about the balance of the needed Indexes. There are some very important diffrences:
- adding an index could support SQL, but in case of RLA several programms have to be rewritten.
- the bigger the granularity of your SQL, the better the SQL optimizer could use prefetching resulting in more asynchronous I/O and less synchronous I/O with less response time, sometimes paid by more CPU
- in some cases the handmade acces plan of a programmer might be better, but in most cases the query engine finds a better access plan (have alook at some postings in this discussion, meaning 10.000 records would be a lot - did you know, that a blockfetch of 1000 records is as fast as reading one record per SQL? Did you know, that a full table scan beats an index sequential access, if more than less than 20% are needed? Did you know that making setll, reading sequential, chaining some related tables is outperformed by far just telling the query engine how the final resultset should be, by one sql statement and let the query engine do its work?

Stay with RLA, if you feel happy with it, but be aware, that you are one of the persons digging the grave for AS/400. RLA is not the cure, its the illness.

D*B

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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 [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.