[GNC] Any performance improvement in GnuCash 5.x?

[Adrien Monteleone]

5.0 didn't make it that far in SQL modernization as planned, though huge 
improvements have been made in preparation for that move.

My db is only about 7 years old, (and no investment stuff, which can 
create lots of transactions for some active folks) but I'm not seeing 
any performance issues.

What OS?

Can you check the Wiki about providing a Tracefile, or maybe run GnuCash 
from the Command Line /Terminal to get some output.

There might be things completely unrelated to SQL/file access that is 
causing a bottleneck.

Regards,
Adrien

On 5/1/23 6:07 PM, Lipp F. wrote:
> I am wondering if users can comment on performance for GnuCash 5.x. I
> remember reading that  GnuCash 5.x is supposed to use proper SQL to query
> the records and not load the entire history of records in memory on startup.
> 
> For the record, I am using pretty new hardware, sqlite database with about
> 20 years of transactions and GnuCash is not responsive at all. Takes like
> tens of seconds for an action to happen after clicking a menu item.