Re: Which is faster? Cursors or Prepared statements?

In article <39cgok$gfd@hudson.lm.com>, Albert E. Whale <aewhale@emi.lm.com> wrote: } 2. I would like to implement the UPDATE cursor (if it's not in the } original SELECT cursor) in either a DECLARED CURSOR FOR UPDATE, } or by EXECUTING a PREPARED SQL statement. } An UPDATE cursor is quicker than a PREPARED sql statment. When using an update cursor, the file pointer (for lack of a better term) is already pointing at the record to be updated. Using a prepared sql statement, although quicker than a non-prepared one, still has to seek to some location in the file before doing the actual update. DAS -- Dave Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.21 UUCP: ..!uunet!das13!dave INTERNET: dave@das13.snide.com