My non-scientific observation is that SQE performs better in most cases
(high 90s percentile). In a lot of cases many orders of magnitude better.
Rather then rely on my observations, take a peek at "Preparing for and
Tuning the SQL Query Engine on DB2 for i5/OS" redbook:

http://www.redbooks.ibm.com/abstracts/sg246598.html?Open

Search on "benchmark".

Elvis

Mike Cain - DB2 for i5/OS Temporary Indexes - The Good, The Bad, The Ugly
October 16
2007 System i Fall Technical Conference | Orlando | November 4-7
Celebrating 10-Years of SQL Performance Excellence on IBM System i, eServer
iSeries and the server affectionately known as the AS/400

-----Original Message-----
Subject: RE: Why buy 5733-Qu2 (Was: 5733QU2 - No Developer Discount)

Right on Pete. SQE rocks.

Michael Crump

-----Original Message-----
Subject: Why buy 5733-Qu2 (Was: 5733QU2 - No Developer Discount)


<snip>

See how existing queries even run better. I bet our resident SQL expert
Elvis can tell us how much better the SQE engine is over the CQE engine, and
guess which one QU2 uses, and guess which one QU1 uses.

You can tell I am excited about this, as I have played with it,
and
it is definitely worth it. I have never seen anything this good on the
AS/400, iSeries, or i5.

Pete

</snip>



This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2019 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].