× 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.



I wondered when you'd chime in.  Let me know when you are ready to
tackle the big picture of the iSeries perception and ways to have it
taken seriously when competing against is internationally recognized
RDBMS rivals.   

And since I have been around for a long time and have faced the big
picture and realized what makes a platform have a future, I try to get
the faithful to recognize the "elephant in the living room".

You're very smart Joe and I keep hoping you'll help me with the big
picture and not hit me on the nits.

Dave       

>>> joepluta@xxxxxxxxxxxxxxxxx 2/23/2006 15:51:38 >>>
I shouldn't bother, but I'm in a mood...

> From: Dave Odom
> 
> Not true about SQL being slower access than RPG.

Yes it is true.  I've proven it over and over.  In single record
access, RPG
beats SQL.  In single record update, it beats it by an order of
magnitude.
Set-based access, as Walden points out, is faster, particularly when
the set
size is over 100 records.  At about ten records, the two are pretty
close.
But for transaction processing (as opposed to data mining), nothing
beats
good old indexed access.


> But the bigger
> picture is if the platform is to compete seriously in the market
place
> against other DBMS platforms it is imperative those using legacy
> programming languages (RPG, CL, etc.) move to using mainstream
languages
> (SQL for sure) and programming methodologies.

SQL is not an application development language.  It is a data access
language.  It has been poked, prodded and manipulated into doing many
of the
things that true application development languages do, but only at the
cost
of lots of strange platform-specific behavior.  Try getting the first
ten
rows of any SELECT in the four or five top databases, and you'll see
what I
mean.

SQL is to databases what C++ is to systems programming.  A really good
language for what it does with a bunch of baggage placed on it that it
was
never intended for.  If you want objects, use a true OO: Java for
strong
typing, something like Python for weak typing.


Anyway, this is hardly going to change minds.  If you've been around a
while, though, you realize that no two business are exactly the same,
and
that there exists a mix of technologies, OO and procedural, GUI and
green
screen, set-based and transaction-oriented, for every business problem.
 And
in the end, those who use the best tools for the job are the ones who
really
understand the bigger picture.


Joe



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.