Re: [GNC] Help breaking up a file
David Carlson wrote: "I think keeping the file on a local SSD would help, tho I cannot verify by personal experience." I have two laptops, one with a spinny drive and the other with an SSD. In 2.6.19, it seems to take each of them pretty close to a minute to open program + data file. (The data file is compressed, 120K, this year's transactions only.) And I just tried it on my SSD desktop at work, and it was very little faster, if faster at all. -- Stan Brown the_stan_br...@fastmail.fm http://BrownMath.com http://OakRoadSystems.com/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help breaking up a file
Eric, GnuCash is known to be slow to open, but there are some tricks to make it faster. One is to just leave it open until you close down your computer. Another is to close all reports before closing GnuCash. I think keeping the file on a local SSD would help, tho I cannot verify by personal experience. Lastly, when release 3.3 or so comes out, it should finally be getting back some of the speed that it has lost in recent years. Hopefully, it will also get back some of the speed in saves, too as they are also painfully slow. David C On Tue, Aug 28, 2018 at 12:23 AM Eric Jensen wrote: > I apparently looked at the file size wrong. It is actually only 1.38 MB. > That is compressed. It does take about 23 seconds to open the file though > from a local drive. I am also using gnucash 2.6.19 > I agree that it is nice to have all the historical data available. But I > don't like waiting so long for it to open every time. And I don't find > myself looking up things older than 3 year very often > > On Mon, Aug 27, 2018, 5:00 AM Colin Law wrote: > > > Wow, that is a lot of personal data, mine goes back to 2001 and is > > only 2MB. Is that the default file type (XML) and have you specified > > Compress files in Preferences > General? > > > > In my opinion it is best to keep all the data in one file, then you > > have immediate access to all the history. So far for me the PC power > > has kept pace with the file size so I have not noticed much difference > > over the years. On Ubuntu mine takes 7 seconds to load the program > > and another 13 to load the user data. That is fetching the data over > > my local network from a Pi file server so would likely be much quicker > > if the file was on the PC. I am using 2.6.19 > > > > What operating system are you using and what do you mean by 'noticeably > > slow'? > > > > Colin > > On Mon, 27 Aug 2018 at 09:39, Eric Jensen wrote: > > > > > > I have been using gnucash to track my personal finances since 2011. I > > have just > > > continued using the same file over the years. At this point it is over > > 45MB and > > > it is noticeably slow when opening it. I realize now that I should > > probably use > > > a new file for each year. Is there any way for me to break up my > current > > file > > > into yearly chunks? I tried exporting all transactions for a year in > CSV > > format > > > and then importing them into a new file that I had created exporting > the > > > accounts, but that seemed to have a lot of errors. Does anyone have a > > simple way > > > to accomplish this? > > > > > > Thanks, > > > Eric > > > ___ > > > gnucash-user mailing list > > > gnucash-user@gnucash.org > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > > - > > > Please remember to CC this list on all your replies. > > > You can do this by using Reply-To-List or Reply-All. > > > -- > Thanks, > Eric > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help breaking up a file
I apparently looked at the file size wrong. It is actually only 1.38 MB. That is compressed. It does take about 23 seconds to open the file though from a local drive. I am also using gnucash 2.6.19 I agree that it is nice to have all the historical data available. But I don't like waiting so long for it to open every time. And I don't find myself looking up things older than 3 year very often On Mon, Aug 27, 2018, 5:00 AM Colin Law wrote: > Wow, that is a lot of personal data, mine goes back to 2001 and is > only 2MB. Is that the default file type (XML) and have you specified > Compress files in Preferences > General? > > In my opinion it is best to keep all the data in one file, then you > have immediate access to all the history. So far for me the PC power > has kept pace with the file size so I have not noticed much difference > over the years. On Ubuntu mine takes 7 seconds to load the program > and another 13 to load the user data. That is fetching the data over > my local network from a Pi file server so would likely be much quicker > if the file was on the PC. I am using 2.6.19 > > What operating system are you using and what do you mean by 'noticeably > slow'? > > Colin > On Mon, 27 Aug 2018 at 09:39, Eric Jensen wrote: > > > > I have been using gnucash to track my personal finances since 2011. I > have just > > continued using the same file over the years. At this point it is over > 45MB and > > it is noticeably slow when opening it. I realize now that I should > probably use > > a new file for each year. Is there any way for me to break up my current > file > > into yearly chunks? I tried exporting all transactions for a year in CSV > format > > and then importing them into a new file that I had created exporting the > > accounts, but that seemed to have a lot of errors. Does anyone have a > simple way > > to accomplish this? > > > > Thanks, > > Eric > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > -- Thanks, Eric ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help breaking up a file
On 08/27/2018 06:36 AM, David Cousens wrote: > Eric, > > What version of Gnucash are you currently using and on what operating > system? > > If it is 3.2, you can export the transactions using the default export > format to a csv file and import them using the same default format. The > format is selectable in the setup assistants for both export (here just use > the default settings in the first pane of the assistant and don't change > them) and on import select the GnuCash Export Setting in the Load and Save > Settings combo box at the top. > > I did this this afternoon with a couple of month's data while testing out > some changes I was making to the importer and it worked flawlessly apart > from one quirk. You have to make sure the default date format when you > import the exported data matches the date format for your locale or whatever > date format you have set in the GnuCash preferences for dates for your > books. > > My understanding is that before v3 GnuCash was unable to easily reimport its > own export data but from V3.0 on this should work OK so if you are using a > v2.6 variant this may be the problem and causing the errors on import. I > would try it with a small block of data initially until you are sure you > have the settings right. > > David Cousens. > > > > - > David Cousens > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > I have thought that a useful feature would be a balance-forward option on the year-end close tool. That option would replace all of the transactions in an account with a single entry that is the balance at the end of the year (or specified date if someone has a fiscal year non-calendar). Since the year-end close just ran, all the income and expense accounts would net to zero. I would have it saved to a new file rather than replacing the old (or ask for a name for the "old" file and write the pre-action file to there). I suppose this could be a stand-alone feature but it seems most useful in conjunction with the "close" option. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help breaking up a file
Eric, What version of Gnucash are you currently using and on what operating system? If it is 3.2, you can export the transactions using the default export format to a csv file and import them using the same default format. The format is selectable in the setup assistants for both export (here just use the default settings in the first pane of the assistant and don't change them) and on import select the GnuCash Export Setting in the Load and Save Settings combo box at the top. I did this this afternoon with a couple of month's data while testing out some changes I was making to the importer and it worked flawlessly apart from one quirk. You have to make sure the default date format when you import the exported data matches the date format for your locale or whatever date format you have set in the GnuCash preferences for dates for your books. My understanding is that before v3 GnuCash was unable to easily reimport its own export data but from V3.0 on this should work OK so if you are using a v2.6 variant this may be the problem and causing the errors on import. I would try it with a small block of data initially until you are sure you have the settings right. David Cousens. - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help breaking up a file
On 8/27/2018 4:59 AM, Colin Law wrote: Wow, that is a lot of personal data, mine goes back to 2001 and is only 2MB. Is that the default file type (XML) and have you specified Compress files in Preferences > General? In my opinion it is best to keep all the data in one file, then you have immediate access to all the history. So far for me the PC power has kept pace with the file size so I have not noticed much difference over the years. However, maybe good to discuss the original question. TWO parts to this, splitting OLD data into separate years vs in the future having separate years. Or perhaps something in between, every several years when the file grows too large, starting over. Yes, it is important to be able to access historical data. But important to consider how often one needs to do that. It doesn't hurt very much if rare operations are slow as long as frequent operations are fast. Thus you could consider (for that third choice) at the end of the current year opening a new set off books for the next year. You would do this from the end of the year Balance Sheet << export the CoA and then plug in the standing account balances from the Balance Sheet >> You then open gnucash with this new set of books for continuing on BUT can always open the old file if and when you need to look at historical data. Personally (for added safety) I would have burned that file (the old books) on ROM medium and when wanting to look at historical data, slip that disk in and then tell gnucash to open* THAT file (rather than the current books). Safe from you accidentally changing something. Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help breaking up a file
Wow, that is a lot of personal data, mine goes back to 2001 and is only 2MB. Is that the default file type (XML) and have you specified Compress files in Preferences > General? In my opinion it is best to keep all the data in one file, then you have immediate access to all the history. So far for me the PC power has kept pace with the file size so I have not noticed much difference over the years. On Ubuntu mine takes 7 seconds to load the program and another 13 to load the user data. That is fetching the data over my local network from a Pi file server so would likely be much quicker if the file was on the PC. I am using 2.6.19 What operating system are you using and what do you mean by 'noticeably slow'? Colin On Mon, 27 Aug 2018 at 09:39, Eric Jensen wrote: > > I have been using gnucash to track my personal finances since 2011. I have > just > continued using the same file over the years. At this point it is over 45MB > and > it is noticeably slow when opening it. I realize now that I should probably > use > a new file for each year. Is there any way for me to break up my current file > into yearly chunks? I tried exporting all transactions for a year in CSV > format > and then importing them into a new file that I had created exporting the > accounts, but that seemed to have a lot of errors. Does anyone have a simple > way > to accomplish this? > > Thanks, > Eric > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Help breaking up a file
I have been using gnucash to track my personal finances since 2011. I have just continued using the same file over the years. At this point it is over 45MB and it is noticeably slow when opening it. I realize now that I should probably use a new file for each year. Is there any way for me to break up my current file into yearly chunks? I tried exporting all transactions for a year in CSV format and then importing them into a new file that I had created exporting the accounts, but that seemed to have a lot of errors. Does anyone have a simple way to accomplish this? Thanks, Eric ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
