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