Re: is it possible to use wait hint with cursor select?

On Thu, 16 Sep 2004 15:24:48 +1000, "Andrew Hamm" <ahamm@mail.com> wrote: >sumGirl wrote: >> Is it possible to use a wait hint in a select done via cursor? Please >> no "dont use cursors" posts, I didnt write the code and I am just >> trying to help a developer. I am not a programmer! > >Why would someone say "don't use cursors" ? That's almost completely the >wrong advice. If you are talking about 4GL then an inline SQL which could be >prepared/declared instead will put more load on the database. >Notwithstanding the recent(ish) addition of an SQL cache which has >admittedly made the situation a lot better. > >Note to self: test the performance differences between cursors vs. lazy-code >that now exploits the cache. Has anyone got any hard reliable numbers that >weren't derived from a highly artificial lab test? > I don't have any hard numbers, but the statement cache performed better than inline SQL, but not as good as a single prepare / declare. JWC