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

[Colin Arndt]

To the Gnucash development team,

This issue has been significantly improved in the latest 5.2 release! 

As noted below, GnuCash 5.1 on my Mac took about 30 seconds to load. This issue did not happen on my Fedora box - it loaded instantly.

It’s now almost 2x faster (18 seconds). A big win!

Thanks for all your work. If you have any sense of why it would have sped up so much, I’d love to hear.
Colin

> On Jun 3, 2023, at 2:50 PM, Colin Arndt <colinfarndt at gmail.com> wrote:
> 
> 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