http://www.perlmonks.org?node_id=953579


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

Replies are listed 'Best First'.
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
[reply]

In Section Seekers of Perl Wisdom