Re^4: fastest method to use DBI

[zwon]

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

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