Re: On Set Optimization Low

Hi. I have proved an applicacion with set optimization low. I didn't notice any difference on performance, except when tables, indexes and store procedures change very often, but a productive environment isn't on this situation. By the way, I had problems due to locks on sysprocplan also. My preferred workaround was directive SET LOCK MODE TO WAIT. In this case applications waits until sysprocplan is released - it waits usually less than a second -. Later Omar Muqoz ----- Original Message ----- From: <jpierrot@chubb.com> To: <informix-list@iiug.org> Sent: Wednesday, December 21, 2005 12:27 PM Subject: On Set Optimization Low > Any thoughts on this folks - Will appreciate it. > Setting "Set Optimization Low" for stored procedures is one of the > suggested workaround. Have not tried it yet. Are you aware of any downfalls > (pros & cons) using it in an environment. Does it impact other objects > directly or indirectly in any shape, form or fashion? Will stored procedure > performance degrade in any way? Are we loosing anything for having this > set? Please advise! > > > Thanks > > jp > sending to informix-list sending to informix-list