http://www.perlmonks.org?node_id=777979


in reply to Re^3: fastest method to use DBI
in thread fastest method to use DBI

Let me to oppose. OFFSET is not good for performance at all (BTW there's no OFFSET in Oracle AFAIK). When you executing query like 

SELECT name,phone ORDER BY name OFFSET 1000000 LIMIT 10

[download]
your database should iterate over first 1000000 records before it will start returning records, this is very slow.

In Section Seekers of Perl Wisdom