Comments (3)
I am aware of the slow performance on large accounts. I have also noticed that on PostgreSQL (though I also suspect that that particular database server is also pretty slow). This is something I am continously investigating, but will have to look into furher. Never had a timeout though. Guess that depends on the database engine. My biggest account is ~1200 transactions.
One of the reasons (I think) is that even though the ledgers are paginated, the backend code still loads all of the splits from the DB and only sorts and filters in the template, see account.j2:75). But even then, sorting a 3500 element list shouldn't take very long.
I'm not sure how to improve on this. Piecash does not (I think) support retrieving only a part of the splits (docs). The best way would be to do the sorting and filtering in the SQL query to reduce the number of loaded results in the first place (if that is in fact the issue here).
On display of the transactions (transaction.j2), only the splits and contra-accounts are accessed, so I see no possible bottlenecks here. I will have to look at the piecash implementation to find out more.
Next step for me is trying out with different databases on different hosts.
Do you really have slow performance (several seconds load time) on any account? Even on smaller ones? With sqlite with my testing dbs I never had any issues (see e.g. https://gnucash-web-demo.bachmeier.cc which runs on PostgreSQL).
I will continue to work on this, but if you find out anything, please let me know!
This issue will serve as the tracking place for load time improvements.
from gnucash-web.
I just tried this out for the first time yesterday and had a similar experience. I built a docker arm image for rpi. The sample sqlite data was loading just fine in the web ui but when I tried using my own gnucash data file (also sqlite with several larger accounts) I couldn't get most of the accounts to load. Haven't gathered as much info as @williamjacksn but I'll be happy to report my findings in case it helps find a common denominator. At first I was suspicious of the arm platform and was going to try on x86_64 next to see if the same thing happens.
Thanks for your work on this @joshuabach, it's a really neat project.
from gnucash-web.
quick update on my end...I did try the latest x86_64 docker image 'out-of-the-box' and found much better performance than on the rpi. The larger accounts are still loading a bit slowly, but it takes at most 4-5 seconds (my arm image was much slower). I do see where there is still room for improvement on x86_64, but as expected, architecture will make a difference too
from gnucash-web.
Related Issues (20)
- How to run gnucash_web flask HOT 4
- Auto-Completion / Suggestions for new transactions
- Contra-Account selection overflowing on mobile
- EncryptedSession uses deprecated Flask attribute HOT 1
- Error when root account does not have a defined commodity HOT 1
- Pipx installation of extras impossible due to spaces HOT 2
- [Wishlist] Add support for transaction linked documents HOT 1
- Unexpected value for identifier HOT 5
- [BUG] Compatibility with Flask >= 2.3.0 HOT 1
- [SUPPORT] Database 'sqlite:///db/gnucash.sqlite' does not exist HOT 6
- User management HOT 1
- Add contribution guide
- Docker - container access denied HOT 3
- Improve error handling on invalid transactions HOT 4
- missing mariadb libraries in k8s deployment HOT 1
- Community Stuff for GitHub HOT 1
- Yahoo finance requires authorization
- Piecash is dead HOT 2
- Offline Support
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from gnucash-web.