[Subject Prev][Subject Next][Thread Prev][Thread Next][Subject Index][Thread Index]
Newbie DBD::Pg question
Just started on postgres a few days back and was having a few questions
about the perl interface to it. According to perldoc DBD::Pg
Although PostgreSQL has a cursor concept, it has not been
used in the current implementation. Cursors in PostgreSQL
can only be used inside a transaction block. Because only
one transaction block at a time is allowed, this would
have implied the restriction, not to use any nested SELECT
statements. Hence the execute method fetches all data at
once into data structures located in the frontend
application. This has to be considered when selecting
large amounts of data !
Frankly speaking I am not sure what the Author is saying here. Anybody
cares to elaborate on the whole paragraph ??? I do have to extract large
amount of data but I am not sure whether it affects me or not.