[Bug]: History not working (Big DB)

Bug Summary

Opening the History section takes ages

Description

Hello all,

I would like to ask, if possible, to address an issue that I am encountering in the History section: I have now quite a big DB of well parsed articles, retrieved from more than 70 feeds (all working, no issues at all there), but when I have to search something and I try accessing the History section it just starts loading the page (in the background on the system I see a SELECT query started in PostgreSQL daemon) but it basically never ends.

Is it possible to make some optimizations in the History section? Maybe improving the pagination as done in the Unread section? Or maybe create also a subsection in the History part dividing the articles by feed to reduce the retrieval of the past articles?

Many thanks

Kind regards

Steps to Reproduce

1. Take a big DB (more than 20GB).
2. Try loading the History section.

Expected Behavior

To open in seconds.

Actual Behavior

It starts loading the page and in the background PostgreSL starts the SELECT, but it takes ages.

Version

2.3.3

Browser

No response

Relevant Logs or Error Output

Additional Context

No response

Checklist

• I have searched existing issues to ensure this bug hasn't been reported before.