Re: Return values ???

---- you wrote: > Gabbard, Mike W. wrote: > > I'm curious too.....when I worked at Wal-Mart, the Informix guys there > > abused us any time we wanted to us a foreach. Back then it was more > > reliable to "not" use a foreach. What has changed??????? > > >> Steve Barnes <SBarnes@IFMG.com> wrote: > >> I am curious as to why a FOREACH is considered better than OPEN, > >> WHILE, FETCH, CLOSE. I always thought that for large numbers of > >> reads, the overhead of a FOREACH instead of the alternative had > >> performance impacts. This was the thought a few years ago, and > >> maybe I am behind the times! > > And now I'm curious too. I have no idea what who was saying that for. > Without detailed knowledge of what your "Informix guys" thought was > up, I cannot say why they were wrong (or right). Unless someone can > come up with some concrete evidence for why a FOREACH loop is > significantly more expensive than a written out loop, then I will > retain my opinion. Please feel free to retain your opinion. If you > ever get me in to review your code, tell me that you were abused in your > childhood for using FOREACH loops and I'll probably manage to forego > abusing you for not using them. Yah pompous git! In the bad old days FOREACH was expensive. That was when people didn't believe a word Informix told them and benchmarked EVERYTHING. These days, no one seems to have time to benchmark. IMNSHO new versions come out so often, you need to upgrade your opinions, not retain them. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com