Re: [GNC] Fw: Upcoming report deprecation
Op zaterdag 18 mei 2019 20:31:58 CEST schreef Matthew Forbis via gnucash-user: > Sending to list from correct email address. > The Average Balance report would seem to have merit in my mind, such as > tracking a portfolio over time, but I decided to test it to see what it's > capable of. In my testing, I found it can be rmostly eplicated by using > the Net Worth linechart graph (most significant difference is you can't > show only the assets line, and it's a line chart instead of a bar chart). > The Average Balance report has the downside of taking about 15-20 minutes > to run and generate the initial report versus the minute or so for the Net > Worth linechart graphic. So, while I think the average balance report has > it's uses, I don't think it's a great report to use. If it were to be > improved, I don't know if I would relegate it to the extra menu, or merge > it entirely with the Net Worth line charts. > I'd be inclined to do the latter. Or extend/improve the flexibility of the Net Worth charts such that it can report what the average balance report does. That's one report less to maintain and less duplication. Regards, Geert ___ 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] Fw: Upcoming report deprecation
Chris, I just ran these reports with the following results: Average Balance ≈ 5 seconds Net Worth Line & Bar Chart ≈ 1.25 seconds each I have 387 accounts total, with 16 (not often used) currencies, that includes my book currency of USD. I’m not sure how to get a good count of transactions however. (first transactions are dated 12/31/15 if that helps) I did a Simple Layout export of my asset accounts and got 6069 transactions. I could export each type, but of course there would be many duplicates. I don’t track stocks. Also, I’m using 3.5 on MacOS Mojave with 16GB RAM. Regards, Adrien > On May 18, 2019, at 8:15 PM, Christopher Lam > wrote: > > These benchmarks are always useful. Would you mind describing > characteristics of your books? e.g. number of accounts, number of > currencies/commodities, approx no.transactions etc? I'm sure 3.5 > average-balance should be faster than prior versions. > > This may be moot if average-balance will be hidden soon, but IMHO the > networth linechart taking 1minute is still an interesting issue and I'd be > keen to know why. ___ 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] Fw: Upcoming report deprecation
Thanks for benchmarks... IMO 1min still too long (and 14mins shocking) but not sure how to try speed this up unless I come across sample (obfuscated) data On Sun, 19 May 2019 at 18:55, Matthew Forbis < matthewdavidforbis1...@yahoo.com> wrote: > Hi Chris, > > On my system, I have about 150-200 Asset and Liability accounts, going > back to 2010. One currency (USD), but about 50 unique commodities. I am > testing on version 3.5 on Windows 10. The default Net Worth Linechart took > 31 seconds to load (This is the accounting period by month with a Weighted > Average as the price source [When using nearest in time it's faster still, > but trying to compare fairly], and all accounts). Average balance took > 14:30 to load the exact same options. > > Thanks, > Matt > > > > > On Saturday, May 18, 2019, 8:15:54 PM CDT, Christopher Lam < > christopher@gmail.com> wrote: > > > > > > These benchmarks are always useful. Would you mind describing > characteristics of your books? e.g. number of accounts, number of > currencies/commodities, approx no.transactions etc? I'm sure 3.5 > average-balance should be faster than prior versions. > > This may be moot if average-balance will be hidden soon, but IMHO the > networth linechart taking 1 minute is still an interesting issue and I'd be > keen to know why. > > > On Sat, 18 May 2019 at 18:33, Matthew Forbis via gnucash-user < > gnucash-user@gnucash.org> wrote: > > Sending to list from correct email address. > > The Average Balance report would seem to have merit in my mind, such > as tracking a portfolio over time, but I decided to test it to see what > it's capable of. In my testing, I found it can be rmostly eplicated by > using the Net Worth linechart graph (most significant difference is you > can't show only the assets line, and it's a line chart instead of a bar > chart). The Average Balance report has the downside of taking about 15-20 > minutes to run and generate the initial report versus the minute or so for > the Net Worth linechart graphic. So, while I think the average balance > report has it's uses, I don't think it's a great report to use. If it were > to be improved, I don't know if I would relegate it to the extra menu, or > merge it entirely with the Net Worth line charts. > > > > Thanks,Matt > > > > On Saturday, May 18, 2019, 7:21:17 AM CDT, Geert Janssens < > geert.gnuc...@kobaltwit.be> wrote: > > > > Hi, > > > > I'm looking at https://bugs.gnucash.org/show_bug.cgi?id=773198 > > This bug proposes to remove a number of reports from the reports menu on > the > > assumption these reports are primarily demo's of what can be achieved in > > gnucash, but have limited actual value. This is about the following > reports: > > > > Average Balance > > Expenses vs. Day of Week > > Income vs. Day of Week > > Sample Report with Examples > > > > Instead of completely removing them I plan to move them to a separate > > "Examples" sub menu (the former "Sample & Custom" menu) and hide this > menu by > > default. It could be made visible by running gnucash with the '--extra' > > command line switch. > > > > If you are actively using any of these reports please let us know which > ones > > and also how these reports benefit you in practice. > > > > Regards, > > > > Geert > > > > > > ___ > > 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. > > > ___ 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] Fw: Upcoming report deprecation
Hi Chris, On my system, I have about 150-200 Asset and Liability accounts, going back to 2010. One currency (USD), but about 50 unique commodities. I am testing on version 3.5 on Windows 10. The default Net Worth Linechart took 31 seconds to load (This is the accounting period by month with a Weighted Average as the price source [When using nearest in time it's faster still, but trying to compare fairly], and all accounts). Average balance took 14:30 to load the exact same options. Thanks, Matt On Saturday, May 18, 2019, 8:15:54 PM CDT, Christopher Lam wrote: These benchmarks are always useful. Would you mind describing characteristics of your books? e.g. number of accounts, number of currencies/commodities, approx no.transactions etc? I'm sure 3.5 average-balance should be faster than prior versions. This may be moot if average-balance will be hidden soon, but IMHO the networth linechart taking 1 minute is still an interesting issue and I'd be keen to know why. On Sat, 18 May 2019 at 18:33, Matthew Forbis via gnucash-user wrote: > Sending to list from correct email address. > The Average Balance report would seem to have merit in my mind, such as > tracking a portfolio over time, but I decided to test it to see what it's > capable of. In my testing, I found it can be rmostly eplicated by using the > Net Worth linechart graph (most significant difference is you can't show only > the assets line, and it's a line chart instead of a bar chart). The Average > Balance report has the downside of taking about 15-20 minutes to run and > generate the initial report versus the minute or so for the Net Worth > linechart graphic. So, while I think the average balance report has it's > uses, I don't think it's a great report to use. If it were to be improved, I > don't know if I would relegate it to the extra menu, or merge it entirely > with the Net Worth line charts. > > Thanks,Matt > > On Saturday, May 18, 2019, 7:21:17 AM CDT, Geert Janssens > wrote: > > Hi, > > I'm looking at https://bugs.gnucash.org/show_bug.cgi?id=773198 > This bug proposes to remove a number of reports from the reports menu on the > assumption these reports are primarily demo's of what can be achieved in > gnucash, but have limited actual value. This is about the following reports: > > Average Balance > Expenses vs. Day of Week > Income vs. Day of Week > Sample Report with Examples > > Instead of completely removing them I plan to move them to a separate > "Examples" sub menu (the former "Sample & Custom" menu) and hide this menu by > default. It could be made visible by running gnucash with the '--extra' > command line switch. > > If you are actively using any of these reports please let us know which ones > and also how these reports benefit you in practice. > > Regards, > > Geert > > > ___ > 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. > ___ 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] Fw: Upcoming report deprecation
These benchmarks are always useful. Would you mind describing characteristics of your books? e.g. number of accounts, number of currencies/commodities, approx no.transactions etc? I'm sure 3.5 average-balance should be faster than prior versions. This may be moot if average-balance will be hidden soon, but IMHO the networth linechart taking 1minute is still an interesting issue and I'd be keen to know why. On Sat, 18 May 2019 at 18:33, Matthew Forbis via gnucash-user < gnucash-user@gnucash.org> wrote: > Sending to list from correct email address. > The Average Balance report would seem to have merit in my mind, such as > tracking a portfolio over time, but I decided to test it to see what it's > capable of. In my testing, I found it can be rmostly eplicated by using > the Net Worth linechart graph (most significant difference is you can't > show only the assets line, and it's a line chart instead of a bar chart). > The Average Balance report has the downside of taking about 15-20 minutes > to run and generate the initial report versus the minute or so for the Net > Worth linechart graphic. So, while I think the average balance report has > it's uses, I don't think it's a great report to use. If it were to be > improved, I don't know if I would relegate it to the extra menu, or merge > it entirely with the Net Worth line charts. > > Thanks,Matt > > On Saturday, May 18, 2019, 7:21:17 AM CDT, Geert Janssens < > geert.gnuc...@kobaltwit.be> wrote: > > Hi, > > I'm looking at https://bugs.gnucash.org/show_bug.cgi?id=773198 > This bug proposes to remove a number of reports from the reports menu on > the > assumption these reports are primarily demo's of what can be achieved in > gnucash, but have limited actual value. This is about the following > reports: > > Average Balance > Expenses vs. Day of Week > Income vs. Day of Week > Sample Report with Examples > > Instead of completely removing them I plan to move them to a separate > "Examples" sub menu (the former "Sample & Custom" menu) and hide this menu > by > default. It could be made visible by running gnucash with the '--extra' > command line switch. > > If you are actively using any of these reports please let us know which > ones > and also how these reports benefit you in practice. > > Regards, > > Geert > > > ___ > 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. > ___ 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.