RE: Embedded SQL - performance question

Sorry off topic.

I saw this piece of code on our system yesterday. I'm still not sure what to
think.

Exec Sql Insert Into myLib/myFile (Pattern, Color, Onhand) VALUES(:Pattern1,
:Color1, :Qty1);

IF SQLCOD = -803;
Chain (Pattern1: Color1) myFile;
IF %found;
Onhand = Qty1;
Update myFilef %fields(Onhand);
Endif;
Endif;


-----Original Message-----
From: Joe Pluta [mailto:joepluta@xxxxxxxxxxxxxxxxx]
Sent: Thursday, May 26, 2011 5:13 PM
To: RPG programming on the IBM i / System i
Subject: Re: Embedded SQL - performance question

On 5/26/2011 3:16 PM, CRPence wrote:

I expect that SQL should be much faster even on a poorly performing
system; almost as fast as the RLA, esp. if the same index is utilized
for both the SQL and RLA.

I've never found a single-record fetch to be anywhere near as fast as
RLA, and I did exhaustive tests; SQL doesn't catch up until the block
size is upped to about 100 records. I could rerun all those tests, but
until someone shows me some evidence SQL has caught up, I have no reason
to repudiate the old data.

Joe