Posted by Serge Rielau on 03/20/06 00:20

Bob Stearns wrote:
> Thank you, again, for helping a learner. Does the 'FOR READ ONLY' clause
> speed up things in general? Should I include whenever I am only
> interested in reading the results? My php version, if it is important,
> is 4.4.
Unfortunately I'm not versed in PHP (yet).
What I do know is that telling what you want is always a good idea.
Some client interfaces always add FOR UPDATE clause to cursors.
Others even go as far as making cursors SCROLLABLE in utter disregard
for the impact for performance.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Back to original message]