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
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
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.
