Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re^4: fastest method to use DBI

by zwon (Monsignor)
on Jul 07, 2009 at 19:19 UTC ( #777979=note: print w/ replies, xml ) Need Help??


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
your database should iterate over first 1000000 records before it will start returning records, this is very slow.


Comment on Re^4: fastest method to use DBI
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://777979]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (3)
As of 2014-09-21 00:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (165 votes), past polls