Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: same query, different execution, different performance

by InfiniteSilence (Curate)
on Feb 14, 2012 at 01:04 UTC ( #953579=note: print w/ replies, xml ) Need Help??


in reply to same query, different execution, different performance

I recommend turning on full logging in PostgreSQL to see if there is a difference in the actual SQL being passed to the server and then run EXPLAIN on the statements if they are different.

Celebrate Intellectual Diversity


Comment on Re: same query, different execution, different performance
Re^2: same query, different execution, different performance
by punkish (Priest) on Feb 14, 2012 at 01:14 UTC
    I have the exact same result being returned from both queries. Do I really need to worry that the queries might be different? I have asked this question on the DBI list. Perhaps they might know what is going on in the internals of DBI which is causing something to go awry with the second query.


    when small people start casting long shadows, it is time to go to bed

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (7)
As of 2014-12-21 14:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (106 votes), past polls