Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: Much slower DBI on RHEL6

by Anonymous Monk
on Feb 06, 2014 at 10:15 UTC ( [id://1073676]=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    SELECT DISTINCT ON (id) id, description
    FROM list_index li
    ORDER BY id, rpt_key DESC;
    
  2. or download this
    SELECT DISTINCT id,
        (SELECT description from list_index li_i
         WHERE li_i.id = li_o.id
         ORDER BY created_at DESC limit 1) AS description
        FROM list_index li_o;
    
  3. or download this
    SELECT id,
        (SELECT description from list_index li_i
    ...
         ORDER BY created_at DESC limit 1) AS description
        FROM
            (SELECT DISTINCT id FROM list_index) li_o;
    

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others perusing the Monastery: (7)
As of 2024-03-28 22:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found