[GNC] SQLite slow to load on macOS but not Linux

Colin Arndt colinfarndt at gmail.com
Sat Jun 3 14:50:50 EDT 2023


Hi all,

I set up Gnucash a few years ago on Linux and have since switched to using it on Mac (Ventura 13.4 on a MacBook Air M1 2020). 

I’ve mainly run it with the XML file, but wanted to take advantage of some add-ons that require a SQL database. After saving as an sqlite3 file on Mac, it now take 30 seconds to load. The XML file opens instantly. (XML file is 18MB, SQLite DB is 12MB, including 9000 transactions and 6000 prices).

Out of curiosity I opened the same SQLite file on an Intel Linux box of similar age to my MacBook Air. GnuCash opened instantly. The issue is only on my Mac.

I’ve taken the following steps time without any difference:

1. Checked and Repaired all accounts
2. Saved file back to an XML then back to an SQLite file, on both my Mac and Linux box
3. Ran sqlite3 database_name 'VACUUM;’ from the Terminal
4. Deleted all price data

Reports of this issue mention 1 CPU spinning up to 100% while the file is loaded into memory - and I see the same behavior.

Any advice on this?

Thanks,
Colin


More information about the gnucash-user mailing list