prevent queries from hanging and blocking other queries

[divine-comedian]

some queries are hanging when the dapp is under load. the hanging queries are preventing other queries from being ran and causing errors for users on the app

[CarlosQ96]

These are some of the queries that are hanging.
There queries that hang the most seems related to querying the recurring donations and selecting the squareroot sum for estimated matching.

[CarlosQ96]

[divine-comedian]

@CarlosQ96 what is the update on this issue?

[CarlosQ96]

I been cleaning the queries manually every now and then. The main query fetching the square root is the culprit.
As I'm finishing issues, ill jump to this between today and tomorrow.

[divine-comedian]

Yikes! Definitely not sustainable to manually clean queries, thanks for investigating and please update us when you have the fix.

[divine-comedian]

was related to cronjob - @CarlosQ96 will keep working on it this week with estimated matching query fixes.

[divine-comedian]

@CarlosQ96 what is the update on this issue?

[kkatusic]

@CarlosQ96 can we introduce here some function and trigger for database, there are a lots of the SUM, COUNT... queries here on this list? only suggestion ;)

[CarlosQ96]

I can make a list of the heaviest queries and see how we can optimize them.