[GNC] Max number of Accounts

[Christopher Treen]

Thanks for the extra info John.

Yes, I am aware of the limitations, but as I said, it works for (just 
me) now.

Despite that, I did play around with Dolibarr, but ran out of capacity 
pretty quickly... I am literally at this moment entering my invoices 
into GnuCash for the parts I bought on Cyber Monday to build a new 
server/NAS over the upcoming Holidays 🙂

Cheers!


On 05-Dec-2025 23:02, John Ralls wrote:
>
>> On Dec 5, 2025, at 9:07 AM, Christopher Treen <ctreen at online.de> wrote:
>>
>> But my question is a simple one: Is there a MAXIMUM number of Accounts, or file size? I currently have 53 parts with one Account per Part Number to track stock levels. This WILL grow with time.
>
> Chris,
>
> There’s no limit to the number of accounts and no software constraints on file size, but you should be aware that GnuCash loads *everything* into memory at the beginning of a session, even when using MySQL or Postgresql as a backend. That might impose a performance limit on how big your data file or database gets.
>
> However GnuCash is just a basic accounting program. It has no inventory management facility and only basic business facilities and a very simple lot manager. As long as you can live with those limitations you’ll be OK, but a proper ERP system would make your life much easier as your business scales up.
>
> Regards,
> John Ralls