Re: Performance of SQL

[rob@xxxxxxxxx]

As opposed to what?  A 'select' statement does one of two things:
1 - A single fetch
2 - Fetches a result set into (in RPG it's a MODS).

The cursor / fetch pair is used when you are retrieving multiple rows 
individually and you wish to do processing on each row.

Making a choice between using just a fetch, or a cursor, is not usually 
done based on performance considerations, but on the application 
requirements.  Otherwise you might as well ask the question "Should I use 
a %subst or the MULT operation to increase performance?"

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





sushmita.s@xxxxxxx 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
04/15/2004 02:06 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
rpg400-l@xxxxxxxxxxxx
cc

Subject
Performance of SQL






I want to improve the performance of my program which uses Interactive 
SQL. I am at present using 'SELECT' statements. Will  Cursor or Fetch 
increase the response time?



Sushmita Sivaraman
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


DISCLAIMER: The information contained in this message is intended only and 
solely for the addressed individual or entity indicated in this message and for 
the exclusive use of the said addressed individual or entity indicated in this 
message (or responsible for delivery
of the message to such person) and may contain legally privileged and 
confidential information belonging to Tata Consultancy Services. It must not be 
printed, read, copied, disclosed, forwarded, distributed or used (in whatsoever 
manner) by any person other than the
addressee. Unauthorized use, disclosure or copying is strictly prohibited and 
may constitute unlawful act and can possibly attract legal action, civil and/or 
criminal. The contents of this message need not necessarily reflect or endorse 
the views of Tata Consultancy Services
on any subject matter. Any action taken or omitted to be taken based on this 
message is entirely at your risk and neither the originator of this message nor 
Tata Consultancy Services takes any responsibility or liability towards the 
same. Opinions, conclusions and any other
information contained in this message that do not relate to the official 
business of Tata Consultancy Services shall be understood as neither given nor 
endorsed by Tata Consultancy Services or any affiliate of Tata Consultancy 
Services. If you have received this message in error,
you should destroy this message and may please notify the sender by e-mail. 
Thank you.