[GNC] Saving in GnuCash painfully slow: what can I do?

classic Classic list List threaded Threaded
11 messages Options
Hmm
Reply | Threaded
Open this post in threaded view
|

[GNC] Saving in GnuCash painfully slow: what can I do?

Hmm
What can I do to speed things up? I am using GnuCash on a Windows 7 system.

Thank you



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Saving in GnuCash painfully slow: what can I do?

Derek Atkins
Hi,

Hmm <[hidden email]> writes:

> What can I do to speed things up? I am using GnuCash on a Windows 7 system.

What version of GnuCash are you using?
What do you define as "painfully slow"?
What backend are you using?

> Thank you

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

--
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       [hidden email]                        PGP key available
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Hmm
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Saving in GnuCash painfully slow: what can I do?

Hmm
Hi, I am using the most recent version. The backend I am using, if I
understand correctly is .xml.

What I mean is saving your data on GnuCash is painfully slow. It takes 10+
minutes even for small banking transactions to save.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Saving in GnuCash painfully slow: what can I do?

David Carlson-4
Please identify the GnuCash version by the number that you see on the
splash screen when the program starts and also mention which operating
system you have. The various recent versions differ significantly under the
hood, and the developers are concerned about which versions are working
better or worse.

It also helps to mention some general information about the type of
computer ie newer laptop,for example, and whether you are using cloud
storage or built-in ssd drive, for example.

David C

On Tue, Jul 10, 2018 at 12:53 AM, Hmm <[hidden email]> wrote:

> Hi, I am using the most recent version. The backend I am using, if I
> understand correctly is .xml.
>
> What I mean is saving your data on GnuCash is painfully slow. It takes 10+
> minutes even for small banking transactions to save.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Saving in GnuCash painfully slow: what can I do?

John Ralls-2
In reply to this post by Hmm


> On Jul 9, 2018, at 10:53 PM, Hmm <[hidden email]> wrote:
>
> Hi, I am using the most recent version. The backend I am using, if I
> understand correctly is .xml.
>
> What I mean is saving your data on GnuCash is painfully slow. It takes 10+
> minutes even for small banking transactions to save.

The XML backend doesn’t save just the transaction, it saves the whole book. Every time. The SQL backend saves each transaction (or more correctly, commits each transaction to the database) when it’s committed in GnuCash.

That said, I tested save time yesterday on Windows with a 53MB (uncompressed) book. Saves took about 50 seconds.

There’s an open bug on the topic, https://bugs.gnucash.org/show_bug.cgi?id=795804 <https://bugs.gnucash.org/show_bug.cgi?id=795804>. Users have reported that they’ve observed a significant speedup by shrinking the window and in once case by turning off display scaling.

Regards,
John Ralls

_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Hmm
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Saving in GnuCash painfully slow: what can I do?

Hmm
I'm using Build ID: 3.2+ (2018-06-24).

Where is the option to change scaling?

Additionally, Auto Clear takes an insanely long time even if I just exit
without changing. I can tell that my cpu is ramped up after a few months and
my task manager shows high cpu usage with Auto Clear.

I am thinking it's best to ditch this application and just save my financial
transactions in Excel or use Mint.  I never had any issues with my Quicken
application.  



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Saving in GnuCash painfully slow: what can I do?

David Carlson-4
I am researching the issue with Auto Clear,as it is something that I have
not seen before.  So far, I found out that it is supposed to be started
from the Accounts window Actions menu and it is supposed to cause a screen
to open where one can try to coax GnuCash into clearing multiple
transactions in one fell swoop, presumably on the account that is currently
highlighted in that window.  Also, it supposedly has been there since 2010,
having been implemented as noted in <
https://bugs.gnucash.org/show_bug.cgi?id=608436>.

However, I cannot seem to get it started, and I am wondering if others,
including Hmm have been able to use it with at least some success.  If so,
how does it work?

David C



On Tue, Jul 10, 2018 at 6:05 PM, Hmm <[hidden email]> wrote:

> I'm using Build ID: 3.2+ (2018-06-24).
>
> Where is the option to change scaling?
>
> Additionally, Auto Clear takes an insanely long time even if I just exit
> without changing. I can tell that my cpu is ramped up after a few months
> and
> my task manager shows high cpu usage with Auto Clear.
>
> I am thinking it's best to ditch this application and just save my
> financial
> transactions in Excel or use Mint.  I never had any issues with my Quicken
> application.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Saving in GnuCash painfully slow: what can I do?

ravenkwill
In reply to this post by Hmm
I'm having a similar problem. Since the last update, my save time has gone
from 30-40 seconds to 1.5 to 2 minutes - more than double.

From about GnuCash: Build ID: 3.2+ (2018-06-24)

Running Windows 10 Pro build 1803 on Surface Pro


Any thoughts would be appreciated

Thanks,
Raven



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Saving in GnuCash painfully slow: what can I do?

John Ralls-2


> On Sep 8, 2018, at 4:11 PM, ravenkwill <[hidden email]> wrote:
>
> I'm having a similar problem. Since the last update, my save time has gone
> from 30-40 seconds to 1.5 to 2 minutes - more than double.
>
> From about GnuCash: Build ID: 3.2+ (2018-06-24)
>
> Running Windows 10 Pro build 1803 on Surface Pro
>


See https://bugs.gnucash.org/show_bug.cgi?id=795804 where several users have found it to be related to redrawing the status bar on HiDPI screens with scaling set to something other than System.

Regards,
John Ralls

_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Saving in GnuCash painfully slow: what can I do?

David Carlson-4
This bug report https://bugs.gnucash.org/show_bug.cgi?id=795804  addresses
Release 3.2 with HiDPI monitors in Windows 10 cases. Also has there been
any attempt to isolate the effect of having reports open?
I also recall that there was a bug report suggesting that having many
backup files in the same folder also slowed down file saves.  Is that true,
and if so does it apply to all OS'es and current and older releases?
Is there any bug report addressing slow response in Linux either with HiDPI
monitors or otherwise?

David C

David C

On Sat, Sep 8, 2018 at 6:38 PM John Ralls <[hidden email]> wrote:

>
>
> > On Sep 8, 2018, at 4:11 PM, ravenkwill <[hidden email]> wrote:
> >
> > I'm having a similar problem. Since the last update, my save time has
> gone
> > from 30-40 seconds to 1.5 to 2 minutes - more than double.
> >
> > From about GnuCash: Build ID: 3.2+ (2018-06-24)
> >
> > Running Windows 10 Pro build 1803 on Surface Pro
> >
>
>
> See https://bugs.gnucash.org/show_bug.cgi?id=795804 where several users
> have found it to be related to redrawing the status bar on HiDPI screens
> with scaling set to something other than System.
>
> Regards,
> John Ralls
>
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Saving in GnuCash painfully slow: what can I do?

John Ralls-2
The files-in-the-directory hypothesis was on the same bug report, but seemed to affect only a few of the people who responded.

GnuCash doesn’t do anything that low-level. It’s most likely to do with the way Cairo handles HiDPI on Windows.

Regards,
John Ralls

> On Sep 8, 2018, at 7:23 PM, David Carlson <[hidden email]> wrote:
>
> This bug report https://bugs.gnucash.org/show_bug.cgi?id=795804 <https://bugs.gnucash.org/show_bug.cgi?id=795804>  addresses Release 3.2 with HiDPI monitors in Windows 10 cases. Also has there been any attempt to isolate the effect of having reports open?
> I also recall that there was a bug report suggesting that having many backup files in the same folder also slowed down file saves.  Is that true, and if so does it apply to all OS'es and current and older releases?
> Is there any bug report addressing slow response in Linux either with HiDPI monitors or otherwise?  
>
> David C
>
> David C
>
> On Sat, Sep 8, 2018 at 6:38 PM John Ralls <[hidden email] <mailto:[hidden email]>> wrote:
>
>
> > On Sep 8, 2018, at 4:11 PM, ravenkwill <[hidden email] <mailto:[hidden email]>> wrote:
> >
> > I'm having a similar problem. Since the last update, my save time has gone
> > from 30-40 seconds to 1.5 to 2 minutes - more than double.
> >
> > From about GnuCash: Build ID: 3.2+ (2018-06-24)
> >
> > Running Windows 10 Pro build 1803 on Surface Pro
> >
>
>
> See https://bugs.gnucash.org/show_bug.cgi?id=795804 <https://bugs.gnucash.org/show_bug.cgi?id=795804> where several users have found it to be related to redrawing the status bar on HiDPI screens with scaling set to something other than System.
>
> Regards,
> John Ralls
>
> _______________________________________________
> gnucash-user mailing list
> [hidden email] <mailto:[hidden email]>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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
[hidden email]
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.