DBI spec

[Timothy Grant]

More questions regarding the DBI spec:

First, is it possible to walk backward through a cursor? All the
fetchXXX() functions appear to only move forwards, however, one of my
SQL books mentions the ability to move backwards as well as forwards.

Second, and very much related to the first, how are the results of a
cursor query stored, are they stored in temporary storage on disk, are
they loaded in memory, etc.

Third, at the moment, given the current size of the results that my
queries retrieve, I can implement the backward cursor movement by using
fetchall() and traversing the resultant list, however, I can forsee
that, given a large result set, that method will cause grief, how have
others resolved the bi-directional cursor traversal issue?

Thanks for your input.


-- 
Stand Fast,
    tjg.

Chief Technology Officer              tjg at exceptionalminds.com
Red Hat Certified Engineer            www.exceptionalminds.com
Avalon Technology Group, Inc.                   (503) 246-3630
>>>>>>>>>>>>EXCEPTIONAL MINDS, INNOVATIVE PRODUCTS<<<<<<<<<<<<