search

amschaal / bioshare

MIT License
6 stars 2 forks source link

Reduce the number of queries hitting db, or cache queries or template fragments. #85

Open amschaal opened 1 month ago

amschaal commented 1 month ago

There are some queries that can probably be optimized, including by joining tables instead of running multiple selects.

Other places, we probably don't need to query the database every request to see if there are bad paths, or new shares shared with the user, etc.

amschaal commented 1 month ago

Logs API is producing a ton of SQL queries. Seemingly one for each log. Fix this.