Strange behavior of GNUCash on large database

perillamint perillamint at gentoo.moe
Mon Jan 23 04:00:26 EST 2017



On 23/01/17 17:43, perillamint via gnucash-user wrote:
> Hello,
> 
> I'm trying to write NodeJS lib which manipulates GNUCash's postgres DB.
> 
> In small number of transactions (10k), it works fine. However, When I
> pour lots of transactions(about 50k) in DB, it starts strange behavior.
> 
> It mixes income and expenses column and displays sum incorrectly.
> (negative value)
> 
> I guess this caused by limitation of GNUcash's ability to handle large
> data. Is there any documented limitation of GNUcash? or does anyone have
> experience like this?
> 
> Thanks.
> 
> p.s. Sorry for bad English. I'm not English native.
> _______________________________________________
> 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.
> 

I tried few more datasets. It seems that strange behavior is triggered
by number of splits. If number of splits exceeds range of signed short,
that behavior starts.


More information about the gnucash-user mailing list