Note that I just proposed a patch (nodes_perf) that changes the code so it doesn't do N lookup queries for N nodes.
I've tested with 10,000 nodes on the page, and while it was slow to load (5s) it still completed, vs failing with an OOPS after a couple of minutes without that change.
I agree that pagination is a good final place to be, but at least we can load pages with ~1000 nodes in a reasonable amount of time.
Note that I just proposed a patch (nodes_perf) that changes the code so it doesn't do N lookup queries for N nodes.
I've tested with 10,000 nodes on the page, and while it was slow to load (5s) it still completed, vs failing with an OOPS after a couple of minutes without that change.
I agree that pagination is a good final place to be, but at least we can load pages with ~1000 nodes in a reasonable amount of time.