Hello, for the moment I keep only titles and summaries, not the full articles. Once the articles become too many (for the moment it's not the case), I will think of some partitioning solutions.

The underlying database is PostgreSQL and it works well under medium load.

Thank you for the comment.