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

[Michael or Penny Novack]

On 5/1/2023 7: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.


I think some misunderstanding here. What did you mean by "GnuCash 5.x is 
supposed to use proper SQL"

As somebody who in his working days who  designed/maintained stuff 
running in the DB2 environment (IBM mainframe SQL) that's the behavior 
you described, only "fetching" just what was needed from the SQL 
database. But DB2 was a "database manager" supporting multiple 
simultaneous users.

The mini SQLs like MySQL, sqlite, etc. are not doing this. Not capable 
of supporting multiple simultaneous users. Reading the whole database 
into core. In the sense that I think you mean "proper", not proper SQL. 
Keep in mind that technology has changed in the last few decades. Most 
of us on our home machines have two orders of magnitude larger core than 
the (then huge) mainframes where I worked. The databases couldn't have 
been read into core as they were much larger than the core.


Michael D Novack