[BUG] DB & page slowdown at high snippet counts

[jordan-dalby]

Describe the bug
At high snippet counts (>500), the page will start to slow (on my machine) since all snippets are rendered at once. It's especially bad when importing a large number of snippets at once, the DB might be struggling to keep up.

To Reproduce
Import 500 snippets at once, wait for page reload

Expected behavior
No performance difference

Screenshots
n/a

Platform
All

Additional context
May be worth migrating to postgresql eventually, would be a good intermediary for user accounts anyway, since sqlite won't support concurrent users.
Snippets should probably be (invisibly) paginated, although we'd need to figure out how to make that work with the current API.

[vlavrynovych]

To fix this type of problem you'll need to re-work your search bar. Once it start to do a lookup to the database you will be able to implement an infinity scroll.

IMHO infinity scroll was never the best option, I always prefer pagination.

With a migration to postgresql and work on user accounts you'll probably need to replace docker parameters of username, password and the tocket by classic registraction like on the Open WebUI or Portainer.

---

As for me, this problem will be a real proble only for a real geek who live with his snippets. I mean that the level of effor needed to solve it today prbably does not worth your time at this stage. I personally would move it for a backlog for a few month to hear about it from a real users. Once you have a big fan base it all will make a ton of sense.