Re: Patch to make SelectQueries work...

From: Tore Halset (halse..vv.ntnu.no)
Date: Mon Apr 18 2005 - 01:58:41 EDT

  • Next message: jira-norepl..bjectstyle.org: "[OS-JIRA] Created: (CAY-307) Error connection Time out, when expired session in DB (Oracle 8.1.7.4)"

    On Apr 18, 2005, at 01:20, Mikaël Cluseau wrote:

    > Here is the method I use to get the same behaviour. I use two queries
    > but it is still faster (in fact, .3 seconds for the request on primary
    > keys and 1.4 to get the full rows from the PKs, I don't really
    > understand why it is that slow

    Have you tried with PostgreSQL explain analyze? It should display what
    PostgreSQL are using its cpu time on.

    http://www.postgresql.org/docs/current/static/sql-explain.html

      - Tore.



    This archive was generated by hypermail 2.0.0 : Mon Apr 18 2005 - 01:59:15 EDT