It takes too long to display one post , or open the main page.
When I first created the Ghost Blog, it didn’t take long.
However, there are currently more than 50,000 posts.
Sometimes it takes more than 20 seconds to find a post in this state.
Is there any way to solve it?
If posts can be separated into different databases or tables within mysql, it will save time, but I don’t think this method will be possible.
Really all depends on your setup, where it is hosted, type of hosting and so on. The issue may simply be a limit you are hitting as set by your hosting provider. A solution for that many posts will likely involve having MySQL on a separate server to improve performance.
Does Ghost have cache feature? I know Drupal does and it reduces RAM usage by a HUGE amount. I’m moving my content from Drupal to Ghost, because like WordPress, Drupal is bloated.