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"