There's no hidden feature in GnuCash. SQL: select count(*) from transactions; and select count(*) from splits;
grep an uncompressed XML file: grep -c '<gnc:transaction>' path/to/file.gnucash; use '<trn:split>' to count the splits. You can also look at the top of your XML file between the book slots and the commodities to find a block that looks like <gnc:count-data cd:type="commodity">406</gnc:count-data> <gnc:count-data cd:type="account">757</gnc:count-data> <gnc:count-data cd:type="transaction">34279</gnc:count-data> <gnc:count-data cd:type="schedxaction">4</gnc:count-data> <gnc:count-data cd:type="price">4505</gnc:count-data> <gnc:count-data cd:type="gnc:GncEntry">1</gnc:count-data> <gnc:count-data cd:type="gnc:GncInvoice">1</gnc:count-data> <gnc:count-data cd:type="gnc:GncJob">1</gnc:count-data> <gnc:count-data cd:type="gnc:GncTaxTable">1</gnc:count-data> <gnc:count-data cd:type="gnc:GncVendor">1</gnc:count-data> Regards, John Ralls > On Aug 8, 2022, at 2:43 PM, R. Victor Klassen <rvklas...@gmail.com> wrote: > > Just out of curiosity, how does one determine those numbers? An SQL query? > grep <pattern> | wc on the xml? Some feature of gnuCash I’ve never > discovered? > >> On Aug 8, 2022, at 3:54 PM, Derek Atkins <de...@ihtfp.com> wrote: >> >> >> On Mon, August 8, 2022 3:21 pm, Robert Simmons wrote: >>>> Accounting systems primarily perform the same operation on large numbers >>> of data elements. >>> >>> I wish I had time to devote to this. I use graph databases in many of the >>> other systems that I develop. This would be a great pivot point on which >>> to >>> create a new open source project and see which paradigm really is better. >>> But really I need to get my data organized and then handed off to an >>> accountant (so I can get back to working on my real work). >> >> My GnuCash database, which has data going back to at least 2007, only >> contains 26781 transactions, with 59582 splits (at least 2 per >> transaction), over a total of 564 "accounts". >> >> Even if you increase by a factor of 10, I doubt you're going to see any >> significant performance differences between databases of similar nominal >> performance. >> >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> >> -derek >> >> -- >> Derek Atkins 617-623-3745 >> de...@ihtfp.com www.ihtfp.com >> Computer and Internet Security Consultant >> >> _______________________________________________ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> ----- >> 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 > ----- > 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 ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
