Re: Query Optimiser

->alan@po.den.mmc.com (Alan Popiel) said: -> ->} It seems to me that cursor declaration and optimization is an area that might ->} be particularly sensitive to the differences between compiled 4GL and RDS. ->} Would some of our friends at Informix care to comment on this? ->jfried@informix.com (Jeff Fried) responded: -> -> Actually there is no difference between the query paths chosen by 4GL, ->RDS, or ESQL. Query optimization is independent of the front-end tools. -> ->... jeff alan@po.den.mmc.com (Alan Popiel) replies: Thanks, Jeff, for the response. However, query optimization was only part of my question. Cursor management is definitely front-end stuff. Without knowing the innards of your tools, it seems to me that a compiler writer MIGHT be able to do more to optimize cursor usage than is possible with an interpreter. On the other hand, for ease of maintenance and upgrading, the Informix 4GL compiler might be designed to generate C code that is logically equivalent to the p-code generated by the interpreter. This might be considered trade secret stuff, so I will understand if Informix chooses not to divulge their approach. However, if a general discussion of this is not considered sensitive, I would like to know which approach Informix took. Some general information on this topic seems like the kind of thing that might be in a manual section entitled "Considerations When Porting Applications between Compiled 4GL and RDS". Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, Tech Ops | / \\ alan@den.mmc.com | P.O. Box 179, M/S 5422 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\