Re: Regarding INFORMIX Basic Details

DA Morgan wrote: > Fernando Nunes wrote: >> DA Morgan wrote: >>> Fernando Nunes wrote: >>> >>>>>> 5. What are the ways to tune a procedure in INFORMIX ? >>>> >>>> Tune the queries it runs... >>>> >>>>> Huh? >>> >>> Assuming the poster is from an Oracle background, as you did above, >>> they are asking not about queries and DML but rather constructs such >>> as loops. Each iteration may be insignificant but the composite may >>> take a very long time to execute. Or it may be a single very fast >>> SELECT followed by some very heavy recursive math .... >>> >>> Perhaps you can point them to the best tool available that is built >>> into Informix. >> >> You're back... I'm so happy... After our last interaction I was afraid >> the fun was gone... >> >> Usually in the Informix world, that kind of work is done in 4GL and >> not in SPL. >> Regards. > > So your message to the OP is that a similar tool does not exist in > Informix? I looked but couldn't find one. It's understandable that you don't understand my English as it's not my native language: My message to whoever read this thread is that the SPL is so simple (take this as you want to extrapolate your thoughts outside the post), that you don't need to tune it... You need of course to tune it's SQL statements. And if you need to debug it, then you can trace it. Regards.