mirror of
https://github.com/actualbudget/actual.git
synced 2026-07-15 22:54:03 -05:00
[GH-ISSUE #2985] Loading large budget databases takes too long #50317
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/actual#50317
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @dymanoid on GitHub (Jul 5, 2024).
Original GitHub issue: https://github.com/actualbudget/actual/issues/2985
Verified issue does not already exist?
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 on GitHub (Jul 5, 2024):
Happy to investigate this.
@youngcw commented on GitHub (Jul 5, 2024):
Please do. It takes super long to download on mobile, even if the budget itself is not especially large.
@quaintdev commented on GitHub (Aug 11, 2024):
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.
@anuneo commented on GitHub (Oct 8, 2024):
I can confirm that this problem exists. I just started using actual budget and imported my data (6.5 years of transactions). After importing, I immediately noticed huge lag in syncing and navigating on the interface. This would unfortunately be a deal breaker for me. I was quite excited to use actual budget. Hope this gets solved soon.
@youngcw commented on GitHub (Oct 8, 2024):
have you tried resetting the budget cache from the settings? Ive heard lots of people say Actual is MUCH faster that other apps when there is many years of data
@quaintdev commented on GitHub (Oct 8, 2024):
I think it's just one time sync that takes time. Once it's synced the lag went away.
From: youngcw @.>
Sent: 08 October 2024 23:10
To: actualbudget/actual @.>
Cc: quaintdev @.>; Comment @.>
Subject: Re: [actualbudget/actual] Loading large budget databases takes too long (Issue #2985)
I can confirm that this problem exists. I just started using actual budget and imported my data (6.5 years of transactions). After importing, I immediately noticed huge lag in syncing and navigating on the interface. This would unfortunately be a deal breaker for me. I was quite excited to use actual budget. Hope this gets solved soon.
have you tried resetting the budget cache from the settings? Ive heard lots of people say Actual is MUCH faster that other apps when there is many years of data
—
Reply to this email directly, view it on GitHubhttps://github.com/actualbudget/actual/issues/2985#issuecomment-2400459438, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOD4LA6IJEY3WOYYWSQCGS3Z2QKJBAVCNFSM6AAAAABKMZJVNGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMBQGQ2TSNBTHA.
You are receiving this because you commented.Message ID: @.***>
@anuneo commented on GitHub (Oct 8, 2024):
Hi @youngcw and @dymanoid,
I reset the cache via settings. Thanks for the hint. I will report again after using actual budget for a day or too.
Meanwhile I am getting this error if I try to open actual budget in a new browser or incognito mode:
I hope the error message above helps. When re-enter the url, then it loads. But every now and then this is displayed:
Edit: If I create a new (empty) budget file, the above errors are not displayed. Only the budget file with all my transactions has this problem. I also tried to export and re-import data. That didn't solve the problem.
Edit2: I am using v24.10.1, in-case you want to know the version I am using. This image was uploaded a few minutes ago.
@mbrevda commented on GitHub (May 9, 2025):
Having the same issue - can't get an initial sync on mobile (Pixel Pro 9)
@anuneo commented on GitHub (May 9, 2025):
I moved to firefly-iii and I am really satisfied with it.
@mbrevda commented on GitHub (May 9, 2025):
I just spent forever moving from Quicken to Actual. Sure hope I dont need to do that all again any time soon
@anuneo commented on GitHub (May 9, 2025):
Well it is actually quite easy with this tool:
https://github.com/firefly-iii/data-importer
@matt-fidd commented on GitHub (Aug 3, 2025):
In general, this isn't reproducable and for anyone coming across a particularly slow budget, it's most likely related to your specific data. In those cases, reach out on Discord for more personalised help. The first steps will always be:
Anyone having the above issue in the future, increase the upload file limit on your server (https://actualbudget.com/docs/config/#actual_upload_file_size_limit_mb) or ask your hosting provider to increase it temporarily for you.