liquid_feedback_core

changeset 415:ffc4c08cd835

When marking first preferences, use JOIN via "initiative" table due to missing index on "vote"."issue_id"
author jbe
date Wed Mar 26 14:26:46 2014 +0100 (2014-03-26)
parents 719ad5c5c940
children db9ccf3c05f4
files core.sql
line diff
     1.1 --- a/core.sql	Wed Mar 26 04:44:58 2014 +0100
     1.2 +++ b/core.sql	Wed Mar 26 14:26:46 2014 +0100
     1.3 @@ -3753,7 +3753,12 @@
     1.4                CASE WHEN "vote"."grade" = max("agg"."grade") THEN TRUE ELSE FALSE END
     1.5              ELSE NULL
     1.6              END AS "first_preference"
     1.7 -          FROM "vote" JOIN "vote" AS "agg" USING ("issue_id", "member_id")
     1.8 +          FROM "vote"
     1.9 +          JOIN "initiative"  -- NOTE: due to missing index on issue_id
    1.10 +          ON "vote"."issue_id" = "initiative"."issue_id"
    1.11 +          JOIN "vote" AS "agg"
    1.12 +          ON "initiative"."id" = "agg"."initiative_id"
    1.13 +          AND "vote"."member_id" = "agg"."member_id"
    1.14            GROUP BY "vote"."initiative_id", "vote"."member_id"
    1.15          ) AS "subquery"
    1.16          WHERE "vote"."issue_id" = "issue_id_p"

Impressum / About Us