rooteco / tweetscape

the supercharged twitter feed
https://prototype.tweetscape.co
GNU Affero General Public License v3.0
18 stars 2 forks source link

Benchmark articles PostgreSQL view #382

Closed nicholaschiang closed 2 years ago

nicholaschiang commented 2 years ago

Imported from @nicholaschiang's original Linear issue TS-23.

Currently switching between clusters in the app takes a noticeable amount of time 1-5s which is not acceptable. I should benchmark how long it takes to query the articles PostgreSQL query, debrief why it takes that long, and then work to either dramatically reduce that query time or cache the query responses every couple of hours (or something).