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



Joe,

When time permits, I'd like to see those bench marks that I can look at
them and see how the experiments were constructed?   Or were they from
someone's actual experience?    That's valid, I'd just like to see how
their experiments were constructed.  

What you claim may be true on the iSeries the way the optimizer and SQL
work, but I have other experiences on the regular DB2s and ORACLE
(possible exception with IMS DC[lighting]).  So, what I say can hardly
be passed off as patently false in all cases on all platforms.   But
this is "niting" again.

>> And somehow, in your perception of "the big picture", the fact that
the  iSeries has BOTH tremendously fast native access and ANSI standard
SQL access means that the iSeries has no future.  I cannot glean any
sense from this statement.<<      

You're not really reading and understanding what I'm saying then.

>> The truth is that most anything you can do in SQL outside of a few
vendor-specific extensions you can do on the iSeries. <<    

 Probably,  using its SQL.

>> And then, when you need extra performance, you can go to native I/O.
 In fact, RPG is the only
language I know of that allows you to access your database both ways,
which in my mind makes it leading edge!<<     

Not a good enough selling point for those outside the iSeries world
looking at an RDBMS and writing the checks.

I really wish you could see what I see and the fact I'm trying to help
the platform (and therefore you and others) compete in the RDBMS market
place. Constantly sparing over "techie" nits will not help.  

Dave


>>> joepluta@xxxxxxxxxxxxxxxxx 2/23/2006 20:53:12 >>>
> From: Dave Odom
> 
> 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.

I'm not "chiming in".  I'm just countering your patently false
statement
that SQL is anywhere near as fast as native I/O for transaction
processing.
The fact is that native I/O is much faster, period.  Until you admit
that
fact up front, the rest of your "big picture" is a waste of time.

You constantly try to edge in statements like "SQL is VERY fast when
the
appropriate indexes... la la la la la".  You ignore benchmarks that
prove
that SQL is up to 10 times as slow as native access on
record-by-record
access.  This constant contradiction of reality removes all credibility
from
anything else you say.


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

And somehow, in your perception of "the big picture", the fact that
the
iSeries has BOTH tremendously fast native access and ANSI standard SQL
access means that the iSeries has no future.  I cannot glean any sense
from
this statement.

The truth is that most anything you can do in SQL outside of a few
vendor-specific extensions you can do on the iSeries.  And then, when
you
need extra performance, you can go to native I/O.  In fact, RPG is the
only
language I know of that allows you to access your database both ways,
which
in my mind makes it leading edge!


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.