impact-graph
impact-graph copied to clipboard
Numerous calls of a query
These queries are called a lot even in simple surfing
SELECT "projectDonationSummaryView"."uniqueDonorsCount" AS "projectDonationSummaryView_uniqueDonorsCount", "projectDonationSummaryView"."projectId" AS "projectDonationSummaryView_projectId" FROM "public"."project_donation_summary_view" "projectDonationSummaryView" WHERE "projectDonationSummaryView"."projectId" = $1
SELECT "projectDonationSummaryView"."sumVerifiedDonations" AS "projectDonationSummaryView_sumVerifiedDonations", "projectDonationSummaryView"."projectId" AS "projectDonationSummaryView_projectId" FROM "public"."project_donation_summary_view" "projectDonationSummaryView" WHERE "projectDonationSummaryView"."projectId" = $1
SELECT "sqrtRootSum", "uniqueDonorsCount" FROM "public"."project_estimated_matching_view" "project_estimated_matching_view" WHERE "projectId" = $1 AND "qfRoundId" = $2
In the latest update by @CarlosQ96, they are cached with 60 seconds of expiration time as default.
Query # 3 about the squareroot sum, needs a compound index with both projectId and qfRoundId to improve further.