Add pagination for account history + transactions to improve performance

[jakobskrym]

Where did this bug occur?

• Local development
• Self hosted app (i.e. Docker)

Describe the bug

There is currently no pagination on the account page which means that it becomes very slow to load when you have a higher number of transactions. Wrote a script to import some transactions from my bank (~1.4k) and it made it so slow that I had to restart the app to get to another page.

To Reproduce
Steps to reproduce the behavior:

1. Ensure >1k transactions or history for given account
2. Go to account page
3. Wait

Expected behavior
Use pagination to prevent long loading times.

Screenshots / Recordings
If applicable, add screenshots or short video recordings to help show the bug in more detail.

Additional context
Realize this is in between a bug and a feature request.

[jakubkottnauer]

@zachgoll I've tracked down the performance problems to the category dropdown (more specifically the transactions/categories/dropdown/row partial). If I comment out the partial here, account with 1k transactions loads without any problems.

[zachgoll]

@jakubkottnauer got it, thanks for looking into this. I'm thinking we'll eventually need some pagination since many credit card accounts will have thousands of transactions in a short time-span, but this could be a good temporary fix if we want to make these rows more of a "read only" row for now.

[jakubkottnauer]

@zachgoll I agree we definitely want pagination here to improve the UX. Though I don't think pagination should be used as a bandaid over performance issues - there's no excuse for the page not being able to handle couple of thousands entries, computers are fast enough 😄 In fact, I'll have a PR coming out in a few moments that fixes the perf problems by moving the category menu content into a turbo frame

[zachgoll]

I think we can close this since #782 drastically improves the performance of large transaction lists.

We can re-introduce pagination as a dedicated feature once we have some designs for it.

[jakobskrym]

Can confirm it's now much better 👍 Nice work @jakubkottnauer