Re: [GNC] Archiving transactions

2019-11-17 Thread M. Rizwan Muzzammil
Hi, I should clarify that when I mean transactions I am referring to double entries. Each business transaction, from the e-commerce stuff I do, outputs on average five double entries: one each for sales, commissions, shipping, coupons and so on. So 500k double entries would yield around 100k

Re: [GNC] Archiving transactions

2019-11-17 Thread D via gnucash-user
Rizwan, I am intrigued. You say you're a new user, but you have 500,000 transactions. Wow! You've been getting the usual kinds of responses to your question: how fast is your computer, how many reports are you running, be patient, don't close Gnucash, etc. But it sounds as if you're pushing

Re: [GNC] Archiving transactions

2019-11-17 Thread David Carlson
There is a setting under Edit > Preferences > General to compress the data file. I think it is selected by default. In Windows 10 compression happens very fast so that is not likely to be an issue with speed. However, because the entire database is [theoretically] in RAM, at some point that

Re: [GNC] Archiving transactions

2019-11-17 Thread M. Rizwan Muzzammil
I will check. Thanks for the suggestion. On Mon, Nov 18, 2019, 10:06 AM Greg Feneis wrote: > It seems like there used to be an option to encrypt, or zip the working > file when it's the default xml type. If that's still an option, and is > enabled, it could cause a delay relative to the file

Re: [GNC] Archiving transactions

2019-11-17 Thread Greg Feneis
It seems like there used to be an option to encrypt, or zip the working file when it's the default xml type. If that's still an option, and is enabled, it could cause a delay relative to the file size Kind regards, Greg Feneis (Pixel 3) On Sun, Nov 17, 2019, 17:49 M. Rizwan Muzzammil wrote: >

Re: [GNC] Archiving transactions

2019-11-17 Thread M. Rizwan Muzzammil
Thanks for your reply. I do not believe it is a hardware issue as this is a new PC. I am running gnucash on Win10 and reading from a, relatively slowish but still very quick, local NVMe SSD. I am using the default file types. Does it make a difference if I change? If so to what other type and

Re: [GNC] Archiving transactions

2019-11-17 Thread M. Rizwan Muzzammil
Thanks for your reply. I don't usually keep reports open so I do not believe it is a reason. Also I recall on an occasion where a report tab, that was kept open, took time to reload on activating the tab. So i assume that time was saved on opening. Will check later today. Slowness is perhaps due

Re: [GNC] Archiving transactions

2019-11-17 Thread Adrien Monteleone
Also note that leaving report tabs open when closing GnuCash will slow it down opening back up as each of those reports is loaded once again. (same goes for all tabs) If your workflow can handle it, either close all tabs except the Accounts tab before exiting, or, don’t close GnuCash unless

Re: [GNC] Archiving transactions

2019-11-16 Thread David Carlson
Slowness to open and to save and close, and even to commit any transaction edit has been a known problem for some time now. Releases after about 3.4 or so are supposed to be much improved, but there may still be slowness if there are a lot of account tabs to open or reports to recreate. There

Re: [GNC] Archiving transactions

2019-11-16 Thread Colin Law
On Sat, 16 Nov 2019 at 18:14, M. Rizwan Muzzammil wrote: > ... > My accounts have a large number of transactions in them. > > This seems to slow the program down, and it take a minute or so to open it > each time. How large is your accounts file (I assume that you are using the default xml file

[GNC] Archiving transactions

2019-11-16 Thread M. Rizwan Muzzammil
Hi all, New user of GNU cash here. My accounts have a large number of transactions in them. This seems to slow the program down, and it take a minute or so to open it each time. Would there be a way to archive older previous year transactions so that the program runs faster? Thanks very much