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


  • Subject: Re: Ok i have a question Concerning Arrays and result sets
  • From: "David Morris" <dmorris@xxxxxxxxxxxxx>
  • Date: Thu, 17 Jun 1999 12:06:05 -0600

Eric,

If you don't want it to build an access path it may help to optimize 
for 1 rows, and specify the correct files using join xxx on xxx syntax.  
If you have a lot of data being returned, you may also be able to 
skip the moving of your data (very slight advantage) by using an 
SQLDA.

David Morris

>>> "Eric N. Wilson" <doulos1@home.com> 06/17/99 10:09AM >>>
I know that the C SQL preprocessor allows you to return an array of host
variables as a programaticly created result set. Question how can I make
this same thing work with ILE???? I have tried everything under the sun and
I still am not able to make it work... Is it that the ILE RPG preprocessor
needs some more work?

The reason that I need to do this is that we need some stored procs that
return data that is spread across 5 files and the response time needs to be
subsecond. Using SQL to create the result set the fastest result I have been
able to achieve has been 30 secs. Naturally the files that I am joining on
have literally millions of records in each one. In addition to the speed
issue there is a need for me to massage the data to make it presentable to
the user... Like converting the dates into Ages etc....  Oh by the way this
is on a 4 processor S30 103 gb disk, and alot of ram.

I created all the indexes that the diagnostic and trace suggested and still
30 secs. The optimizer is still creating an access path every time. I would
belive that this is due to the joins.

I have been able to create a RPG program that returns a single instance and
running it X number of times happens in the sub second range. This is due to
me using navigational access (which face it we can optimize better than any
sql process).

Being able to return an array of Data Structures or something like that
would be the ticket

Thanks in advance
Eric

______________________________________________
Eric N. Wilson
President
Doulos Software & Computer Services
2913 N Alder St
Tacoma WA 98407


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *


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.