Loading project page takes a long time

[Iona Augustine]

Hi,

We have issue of taking a long time when loading project pages and just project pages. It takes 10-18 minutes, depending on how big the project is.

The server and database server performance are decent, if not, everything should be slow as well.

Has anyone here ever experience this as well?

Thanks!

[Mia Tamm]

Hi @Iona Augustine

Why it’s slow

1. Unindexed database queries – Looking through millions of rows without an index can take minutes.
   
   
2. No caching – Every page load rebuilds everything from scratch.
   
   
3. Too much data at once – Returning thousands of items in one go is slow to serialize and send.

How to fix it

1. Add appropriate indexes on the columns your queries filter or sort by.
   
   
2. Introduce a cache (Redis, Memcached or your framework’s cache) so repeat views are fast.
   
   
3. Paginate or lazy‑load large lists so each page only handles a small chunk.

First step: Turn on simple timing (or a profiler), see whether the database, the cache layer, or the network is the bottleneck, then apply one of the above fixes.

— Mia Tamm from Simpleasyty