Description of the need
The function menu_navigation_links_rebuild() uses a large number of database queries when rebuilding the system menu links that are created based on hook_menu. This process uses nearly 300 database queries without any contributed modules, and gets more expensive the more modules you have.
Proposed solution
These queries can be statically cached during the process and then all written back to the database at the end. Based on my initial testing, this reduces test execution time by 10-15%
Additional information
I had to modify one test that deletes menu items without using menu_link_delete to simulate a database crash. The behavior in this case is changed because the links are stored using a static cache.
PR: https://github.com/backdrop/backdrop/pull/3659
Advocate: @hosef
Recent comments
Try using caching in the View settings, set to 24 hours. This should work for anonymous site visitors.
View to show a different node each day
That would actually be a nice usability improvement. A lot of people already build search pages with Views, so having an easier way to convert the default search results into a View would make...
[UX] Convert search to a view.
Have you already played with Views random seed? I belief, what you try to achieve would work with that module. Show only one node and set the sort order to "Global: Random seed" with "...
View to show a different node each day