This very much depends on the database and its driver. I know of databases/drivers that always slurp the complete query result to the client machine. The (Perl) client then can ask the DB driver for rows, which are satisfied from the transferred query.