RE: EXEC SQL vs. CHAIN performance considerations

[Alan Campin <Alan.Campin@xxxxxxx>]

Complex SQL would imply to me that you talking about multiple files. If true, 
then SQL should be faster than chaining in a whole series of files. As 
mentioned in other post, selecting multiple records (Set at a time processing) 
is almost always going to be faster than using record I/O. 

Start with the SQL. If it gives you decent performance, why worry?

-----Original Message-----
From: Brian Piotrowski [mailto:bpiotrowski@xxxxxxxxxxxxxxx]
Sent: Monday, June 06, 2005 5:01 AM
To: RPG programming on the AS400 / iSeries
Subject: EXEC SQL vs. CHAIN performance considerations


Hi All,

 

I have a rather complex SQL statement that I have been using the in the
SQL interpreter to retrieve data from a physical file.  I am toying with
the idea of implementing this code into my RPG program instead of
writing code using chain, setll, etc. to accomplish the same thing.

 

Can I expect a significant performance hit in using this method of data
manipulation instead of using the native commands to access data on the
physical file?

 

Thanks!


Brian.

 

-=-=-=-=-=-=-=-=-=-=-=-=-=-

Brian Piotrowski

Specialist - I.T.

Simcoe Parts Service, Inc.

Ph: 705-435-7814 x343

Fx: 705-435-6746

bpiotrowski@xxxxxxxxxxxxxxx

-=-=-=-=-=-=-=-=-=-=-=-=-=-