Make the landing page faster to load

[code-geek]

Description

Right now since we load all the data all at once, the landing page has become very slow (over 2 seconds to load every single time).

The goal of this issue is to make the landing page faster.

Implementation Considerations

• Django ORM select_related etc can be implemented to fetch data more judiciously
• Lazy load data on the homepage with infinite scroll that calls API (pagination on the server side instead of pagination on the client side)
• Caching (redis/memcached)
• Database indexes
• How does this affect Universal Search

Deliverable

• A faster landing page

Dependencies

No response

[Kirandawadi]

This task is currently on hold due to its complexity. I will focus on other tasks before returning to this one.

[CarsonDavis]

I am hopefully working on a benchmarking suite for some of the backend processes, specifically with pattern application times. Hopefully we will be able to tie these two tasks together once that work is finished.

This task will be taken up in 25.2.