Loading large budget databases takes too long

dymanoid commented 3 months ago

Verified issue does not already exist?

[X] I have searched and found no existing issue
[X] I will be providing steps how to reproduce the bug (in most cases this will also mean uploading a demo budget file)

What happened?

When the database contains a lot of transactions (in my case: 50 accounts, 10k+ transactions), the budget file opening takes too long. On mobile, this can be 20-30 seconds, which is especially annoying when you open the app just to quickly add a new transaction. On desktop, it's a bit faster but still not user-friendly.

The initial sync from the server takes too much time as well. On mobile, it takes several minutes to process everything when first selecting a budget file to download.

This should be optimized. The app startup and the last budget file load should be as quick as possible (maybe using a background activity for things not immediately required right away).

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Chrome

Operating System

Linux

dymanoid commented 3 months ago

Happy to investigate this.

youngcw commented 3 months ago

Happy to investigate this.

Please do. It takes super long to download on mobile, even if the budget itself is not especially large.

quaintdev commented 1 month ago

I have 6 months of data and transactions less than 500 with budget defined for every month. It still takes 30-40 seconds to load on mobile.

I should mention that this happens only for the first time when file is not available on device and I have to open one.

actualbudget / actual