Big projects are slow

[myieye]

Describe the feature

I recently opened an 11,000+ entry project on my phone.
It felt like it took 5+ seconds to load the entries.
So, searching (and especially clearing my search filter) were really painful.
Not cool.

I opened the same project on my laptop and measured:

3.3s to load 10_000 entries
0.5s to load 1_000 entries
: 2.8s faster! 6.5x performance boost!

2.3s to query 10_000 entries from the DB and only return 1_000 to the API

entry.Finalize(complexFormComparer);
if (i < 1000) yield return entry; // else ignore the entry and just keep iterating

: 1.8s saved by not returning from API
: 1.0s saved by not returning from DB

Note: commenting out the call to Finalize() for each entry in the API didn't have a noticeable effect.

Who is this feature for?
Editors. Especially with slower devices.

Pages affected
Browse and tasks

For infinite scrolling using our virtual-scrolling component see:
https://inokawa.github.io/virtua/?path=/story/basics-vlist--infinite-scrolling