Re: Ok i have a question Concerning Arrays and result sets

["David Morris" <dmorris@xxxxxxxxxxxxx>]

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          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *