Re: Benefits of cursors?

In article <2t1tgb$oab@msuinfo.cl.msu.edu> mcfallry@cps.msu.edu (Ryan L Mcfall) writes: > We were just wondering if anyone can explain what Informix does with > a cursor that makes it more efficient than a select statement? Does > it circumvent optimizing the statement multiple times? > As I understood it, a cursor is the device used to align the different impedances between some application program and the relational model. A query may return a whole bunch of rows, whereas a sequential program must get them one by one. H. Thank God, Monday's only once a week -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= /M/A/I Deutschland GmbH, Softwarezentrum Koeln Heinrich Seebauer Mathias-Brueggen-Str. 85 Software Engineering 50829 Koeln, Federal Republic of Germany Phone: x221/956400-0 Phax: x221/956400-69 emale: heinrich@mai.de =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=