Expert Database re-structuring help
Budget: £36 – £0 GBP
Should I migrate database from postgres to something like redis for speed?
I have a news web app in development and postgres stores user data (credentials), as well as the news data from the scraper which is displayed on frontend.
We have an ability for related news but its loading the data way too slowly from postgres so thinking to take the news data out of postgres and into redis to optimise speed and have near instant results for front end user.
Shoudl I migrate all user data also to postgres also or keep them seperate?
Is mongo preferable over redis for something like this?
I have a news web app in development and postgres stores user data (credentials), as well as the news data from the scraper which is displayed on frontend.
We have an ability for related news but its loading the data way too slowly from postgres so thinking to take the news data out of postgres and into redis to optimise speed and have near instant results for front end user.
Shoudl I migrate all user data also to postgres also or keep them seperate?
Is mongo preferable over redis for something like this?