impact-graph icon indicating copy to clipboard operation
impact-graph copied to clipboard

Numerous calls of a query

Open aminlatifi opened this issue 9 months ago • 2 comments

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

aminlatifi avatar May 06 '24 08:05 aminlatifi

In the latest update by @CarlosQ96, they are cached with 60 seconds of expiration time as default.

aminlatifi avatar May 06 '24 08:05 aminlatifi

Query # 3 about the squareroot sum, needs a compound index with both projectId and qfRoundId to improve further.

CarlosQ96 avatar May 06 '24 14:05 CarlosQ96