[GNC] 4.4 slow

[R. Victor Klassen]

As a follow-up 

I tried check and repair and ran into an infinite loop in accts receivable and accounts payable.  

I tried check and repair on descendants of income and expense but no effect

I tried backing off to 3.11 to no avail 

John suggested it was my machine so I moved to a fresh (but only slightly newer) machine. Nothing. 

As a last resort I saved to XML and it opened quickly.  Progress at last.  Wanting the transactional behaviour of SQLite I saved again as SQLite and it now appears fast.  

So there was something mysterious about the file that seems to have been repaired. 

Sent from my iPhone

> On Feb 8, 2021, at 10:50 AM, R. Victor Klassen <rvklassen at gmail.com> wrote:
> 
> When I came in check & repair was in an infinite loop in accounts receivable. 
> 
> The progress log shows it counting up to about 1000 out 6614 and then restarting at 0. Not clear whether a profile of check and repair is useful.  System is relatively unresponsive while I try to interrupt it
> 
> Sent from my iPhone
> 
>> On Feb 5, 2021, at 3:30 PM, John Ralls <jralls at ceridwen.us> wrote:
>> 
>> 7 minutes is a lot. If it's still doing that after the C&R finishes then please open a bug and attach a profile.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>>> On Feb 5, 2021, at 12:21 PM, R. Victor Klassen <rvklassen at gmail.com> wrote:
>>> 
>>> It definitely does beachball long enough. 
>>> 
>>> Might be able to get a profile. 
>>> 
>>> It’s been in check and repair for a bit over 2 hrs now so I am guessing any further probing will be Monday.  For what It’s worth it was in excess of 7 minutes of CPU time last time I started (from a crash).  Minimal disk activity. Reasonable memory pressure 
>>> 
>>> Sent from my iPhone
>>> 
>>>>> On Feb 5, 2021, at 1:57 PM, John Ralls <jralls at ceridwen.us> wrote:
>>>> 
>>>> Does it beachball long enough to get a process sample out of Activity Monitor? Better yet, do you know your way around Xcode well enough to get a time profile?
>>>> 
>>>> Regards,
>>>> John Ralls
>>>> 
>>>>> On Feb 5, 2021, at 9:57 AM, R. Victor Klassen <rvklassen at gmail.com> wrote:
>>>>> 
>>>>> I should also say I’m using the SQLite back end. 90% or more of what I do passes though the business features. When I say entering an invoice line is slow I mean that when I hit tab to get past the last entry and start a new one I sometimes see the spinning lollipop. 
>>>>> 
>>>>> Trying check and repair to see if it makes a difference 
>>>>> 
>>>>> Sent from my iPhone
>>>>> 
>>>>>>> On Feb 5, 2021, at 11:41 AM, Adrien Monteleone <adrien.monteleone at lusfiber.net> wrote:
>>>>>> 
>>>>>> And on that note, it is always recommended when stepping between major versions to run Actions > Check & Repair > Check & Repair All. (which should accomplish such data translations all in one go)
>>>>>> 
>>>>>> I forgot to add that I'm using the SQLite backend. Not sure if that makes a difference.
>>>>>> 
>>>>>> Regards,
>>>>>> Adrien
>>>>>> 
>>>>>>> On 2/5/21 10:28 AM, David Reiser via gnucash-user wrote:
>>>>>>> My memory is a bit fuzzy, but version 4 made some significant changes to (I think) a number of key-value structures in the database. The first time you open version 4, it has to convert all the old values (if you have done lots of transaction importing, that’s a big contributor). If you quit gnucash before it’s done with the conversion, it  has to start over the next time. I think it took something like 45 minutes before my Mac was done updating everything internally in the database.
>>>>>>> After that it has been fine.
>>>>>> 
>>>>>> _______________________________________________
>>>>>> gnucash-user mailing list
>>>>>> gnucash-user at gnucash.org
>>>>>> To update your subscription preferences or to unsubscribe:
>>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>>>> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>>>>> -----
>>>>>> Please remember to CC this list on all your replies.
>>>>>> You can do this by using Reply-To-List or Reply-All.
>>>>> _______________________________________________
>>>>> gnucash-user mailing list
>>>>> gnucash-user at gnucash.org
>>>>> To update your subscription preferences or to unsubscribe:
>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>>> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>>>> -----
>>>>> Please remember to CC this list on all your replies.
>>>>> You can do this by using Reply-To-List or Reply-All.
>>>> 
>>