Reports very slow to open

Sat Jan 27 11:51:43 EST 2018

I can’t time report loading on my macs in 2.7.3 — gnucash crashes whenever I try to create a report. No problems or slowdowns with 2.6.19
--
Dave Reiser
dbreiser at icloud.com


> On Jan 27, 2018, at 11:39 AM, R. Victor Klassen <rvklassen at gmail.com> wrote:
> 
> This is quite dramatic.  Probably my favourite thing to do in code is to make it faster.  (Un)fortunately I don’t run Windows, so I have little to offer here.  The sudden and dramatic change raises the question of what changed?   And I haven’t noticed this issue on the Mac, so I’m guessing the change was only on Windows.  Which in itself supports the theory that the change happened not within GnuCash but in one of its dependencies.  
> 
> But then, I try hard never to close GnuCash down, so I’m not sure I would have noticed.   
> 
> The subject line refers to reports - the sample being tested has many large reports open at startup, as I understand it.   But if “Loading User Data” precedes the start of building reports, it wouldn’t seem that’s the issue - unless building open reports is part of “Loading User Data”...
> 
> I’d be curious whether the startup time on an Sqlite3 file format would show the same pattern.
> 
> 
>> On Jan 26, 2018, at 1:00 AM, David Carlson <david.carlson.417 at gmail.com> wrote:
>> 
>> Here are the times to fully open my data file on my Windows 7 laptop.
>> 
>> 2.6.18 to open 6,480 KB compressed XML file on C: drive
>> 3:14:21
>> 2.6.16 to open 82,605 KB uncompressed XML file on C: drive
>> 3:06:97
>> 2.6.18 to open 6,480 KB compressed XML file on LAN mapped to U:  3:54:00
>> 
>> 2.7.3 to open 6,484 KB compressed XML file on C: drive
>> 6:36:85
>> 2.7.3 to open 80,747 KB uncompressed XML file on C: drive
>> 6:41:29
>> 2.7.3 to open 6,484 KB compressed XML file on LAN mapped to U:    7:25:00
>> 
>> For release 2.7.3 it takes just over 4 minutes to finish 'Loading User
>> Data" and start building register tabs in the main window.  Release 2.6.18
>> took about 1 minute 50 seconds to finish 'Loading User Data" and start
>> building register tabs in the main window.
>> It looks like that part of the process is the first place to look for ways
>> to speed it up.
>> 
>> I am not sure why the uncompressed file loaded more slowly with 2.7.3.  I
>> did change the date of one transaction to make the file 'dirty' to get it
>> saved in uncompressed format.
>> 
>> Also, I think it is known that release 2.7.3 is unable to install F::Q,
>> even via the manual program link in the GnuCash program group of the
>> Windows 7 start menu.
>> 
>> David C
>> 
>> On Thu, Jan 25, 2018 at 6:35 PM, John Ralls <jralls at ceridwen.us> wrote:
>> 
>>> David,
>>> 
>>> Maybe just to rule it out as an issue you could temporarily put it on a
>>> local drive.
>>> 
>>> How big is it? It's XML, right? See if turning compression on or off makes
>>> a difference.
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> 
>>>> On Jan 25, 2018, at 3:15 PM, David Carlson <david.carlson.417 at gmail.com>
>>> wrote:
>>>> 
>>>> I failed to mention that my data file is not on my "C" drive, it is on a
>>>> LAN file-server, but the entire path is via 100 MHz Ethernet, no Wi-Fi.
>>>> 
>>>> David C
>>>> 
>>>> On Thu, Jan 25, 2018 at 2:45 PM, David Carlson <
>>> david.carlson.417 at gmail.com>
>>>> wrote:
>>>> 
>>>>> Preliminary results comparing release 2.6.18-3 with 2.7.3 on a Dell
>>>>> Precision 7510 laptop running Windows 7 sp1 64 bit with a Intel(R)
>>> Core(TM)
>>>>> i7-6820HQ CPU @2.70Ghz and 24.0 GB installed RAM and all updates
>>> installed
>>>>> except a recent Dell display driver update and the Spectre patch update
>>> is
>>>>> not installed yet(?):
>>>>> 
>>>>> Opening a copy of my current data file with scads of tabs including
>>>>> several reports, and a read-only register tab.
>>>>> 
>>>>> In 2.6.18-3 it took 3 minutes 54 seconds to complete opening the file
>>> with
>>>>> no Since Last Run interruption.
>>>>> 
>>>>> In 2.7.3 first touch it took 8 minutes 25 seconds to the metadata
>>> migrated
>>>>> window.
>>>>> 
>>>>> Second opening 7 minutes 5 seconds.  I have many more details to share
>>>>> elsewhere.
>>>>> 
>>>>> David C
>>>>> 
>>>>> 
>>>>> On Thu, Jan 25, 2018 at 1:09 PM, Geert Janssens <
>>>>> geert.gnucash at kobaltwit.be> wrote:
>>>>> 
>>>>>> Op donderdag 25 januari 2018 17:17:48 CET schreef David Carlson:
>>>>>>> About not seeing Geert's message in the Gmail instance in Firefox on
>>> my
>>>>>>> laptop, on that machine gmail put it into spam because it did not meet
>>>>>>> their lofty standards for authentication.  On the Gmail app on my
>>>>>> Samsung
>>>>>>> phone, it was in the Inbox.  Most of Geert's other messages this
>>> morning
>>>>>>> went to my inbox on the laptop.  Go figure!?!  🤔
>>>>>>> 
>>>>>>> David C
>>>>>>> 
>>>>>> Yeah, I don't know what I ever did to upset Google that much they want
>>> to
>>>>>> delegate me to the spam box... I tried to say I'm sorry but they didn't
>>>>>> want
>>>>>> to hear it ;)
>>>>>> 
>>>>>> Geert
>>>>>> 
>>>>>> 
>>>>>> 
>>>>> 
>>>> _______________________________________________
>>>> gnucash-user mailing list
>>>> gnucash-user at gnucash.org
>>>> 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.
>>> 
>>> 
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> 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.
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.