Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
John Carlson — — source: Usenet: comp.databases.informix
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.