Strange behavior of GNUCash on large database

perillamint perillamint at gentoo.moe
Mon Jan 23 04:02:36 EST 2017



On 23/01/17 18:00, perillamint via gnucash-user wrote:
> 
> 
> 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.
> _______________________________________________
> 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.
> 

Nevermind. It seems my dataset contains some wrong data.

Sorry for wrong info.


More information about the gnucash-user mailing list