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



RPGLE is not "definitely much faster" than SQL.

RPGLE is faster when working one record at a time.  Once you start
working with multiple records, then SQL moves ahead.

HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Troxclaire
> Sent: Thursday, March 30, 2006 3:57 PM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: RE: SQL Update in RPGLE.
> 
> All the inputs are correct and I agree that there is no need 
> for SQL if only 
> one file is involved but I already have a ready made 
> complicated SQL query 
> so I wanted to go the SQL way. I agree that F specs were not 
> needed at all. 
> The update query ran just fine when I added "WITH NC" at the 
> end of the SQL 
> statement.
> 
>   It would be very interesting to see some input on 
> performance when it 
> comes to SQL compared to RPGLE. RPGLE would definitely be 
> much faster but 
> just wondering by how much. I have atleast 12 files in my 
> UPDATE statement.
> 
> Cheers,
> 
> Mike.
> 
> _________________________________________________________________


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.