Limits of gnucash

[David T.]

I replied to this earlier, but since you have sent it again (or perhaps it just appeared in my inbox again?), I will wonder at what precisely you mean by “hit the 16 bit limit”? It sounds as if your old accounting program used a sequential 16-bit number for its ID, limiting the effective number of entries to 64K. Is that right? 

If so, then you can rest easy with GnuCash; it uses guid’s for IDs; there is effectively no upper limit on these IDs. And, as you have heard, numerous users have files that are rather substantial in size (although not necessarily the 150K transactions you specified). 

The primary complaint that users have with large GnuCash data files is their load time, and running reports. Both tend to slow down significantly as the file size grows. However, a slow program still will run the numbers.

HTH,
David

> On Jan 10, 2017, at 3:51 AM, Balazs Gaal <balazs at gaal.eu> wrote:
> 
> Thanks, David.
> It looks like I should be a bit more specific with my question ☺.
> 
> I am considering to move to a new accounting system from my old one and gnucash is one of the options I am evaluating.
> One of the reasons to move, among others, is that the old one (or, rather the ancient one, dating back to the 90-s ☺) has hit the 16bit limit with the number of transactions. (Not the first time). Of course, to roll up the old transactions and have an archive system is always an option but I would prefer to have everything in one place.
> 
> That’s why I would like to know whether gnucash can tackle with let’s say one hundred thousand or one hundred and fifty thousand transactions.
> 
> How many transactions do you have in your books when you say “I just purchased a new computer with 8Gig Ram and a I7 cpu ant it still cranks pretty slow on my data file in Windows 7”?  (Haven’t you considered to purchase an SSD? Sometimes it can make miracles ☺). Is gnucash able at all to use more than one core of the CPU simultaneously?
> 
> Regards
> 
> Balázs
> 
> From: david.carlson.417 at gmail.com [mailto:david.carlson.417 at gmail.com]
> Sent: Monday, January 9, 2017 11:10 PM
> To: Balazs Gaal <balazs at gaal.eu>; gnucash-user at gnucash.org
> Subject: Re: Limits of gnucash
> 
> 
> There is no simple measure of "limits".  Yes, GnuCash does keep the entire file in memory, but, as you know, your computer automatically swaps pages of memory between RAM and nonvolatile memory as needed.
> 
> 
> 
> I just purchased a new computer with 8Gig Ram and a I7 cpu ant it still cranks pretty slow on my data file in Windows 7.  On the other hand an 8year old Dell tower with only 2 G of Ram running Linux runs a lot faster.
> 
> 
> 
> David C
> 
> 
> Sent from my LG G Pad 7.0 LTE, an AT&T 4G LTE tablet
> 
> 
> 
> ------ Original message------
> 
> From: Balazs Gaal
> 
> Date: Mon, Jan 9, 2017 3:41 PM
> 
> To: gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>;
> 
> Subject:Limits of gnucash
> 
> 
> 
> Can anybody let me know what the limits of gnucash are?I have read in an earlier post to this list that gnucash keeps the transactions in memory. Any guess, how many transactions can be handled on a windows-10 PC (64 bit) with 4GB memory?Any other practical limits e.g. due to icreased response time, etc?RegardsBalazs Gaal_______________________________________________gnucash-user mailing listgnucash-user at gnucash.orghtt<mailto:%20listgnucash-user at gnucash.orghtt>ps://lists.gnucash.org/mailman/listinfo/gnucash-user-----Please<http://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 at gnucash.org
> 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.