Syntactic Confectionery Delight | |
PerlMonks |
Re^4: fastest method to use DBIby zwon (Abbot) |
on Jul 07, 2009 at 19:19 UTC ( [id://777979]=note: print w/replies, xml ) | Need Help?? |
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 your database should iterate over first 1000000 records before it will start returning records, this is very slow.
In Section
Seekers of Perl Wisdom
|
|