search

hicommonwealth / commonwealth

A platform for decentralized communities
https://commonwealth.im
GNU General Public License v3.0
67 stars 44 forks source link

:bucket: Query Optimization #8005

Open timolegros opened 5 months ago

timolegros commented 5 months ago

Description

This bucket encompasses all sub-tickets whose aim is to optimize high-impact queries. Optimizing a query can mean many things like removing joins/data that is no longer necessary or refactoring the query so that the query plan recognizes it can use existing/new indexes.

I recommend using https://explain.dalibo.com/ to better visual query plans. This will help to identify problematic portions of your queries.

Queries to Optimize

ForestMars commented 3 months ago

Given that the only sub-task in this bucket is #8004 (Datadog queries), I'm closing the bucket, as 804 can be stand alone.

timolegros commented 3 months ago

To anyone else who may view this ticket, please do not close it. #8004 was the prerequisite for creating the list of high-impact queries we need to optimize.