rage / mooc.fi

https://mooc.fi
5 stars 6 forks source link

fix ssr caching; remove unused user text search index #1160

Closed mipyykko closed 1 year ago

mipyykko commented 1 year ago

Create a new cache on every server-side request; use same cache on client side with same user/locale combination.

Make the front page loading quicker with a few indexes and removing unnecessary joins on conditional languages when the field resolver will do the job anyway.

Trigram indexes on user fields were not used and slowing inserts/updates down; will use generated tsvector when we update PSQL -- generated columns require at least version 12.