[Kmymoney] Database Performance Issue

[Brendan Coupe]

J
oe,

I'm not a developer but I thought I'd share my experience on the off chance
it will help you.

I always run a very recent version of KMM that I compile from the git
source so that's one difference (currently 4.6.90-blahblahblah).

I have over 10,000 transactions.

I do not use a SQL database. I use an XLM file that is encrypted. I'm
wondering it if you have exported to XLM a if so do you still have the same
performance problem?

KMM was running very slowly for me. It was slow to start up and every time
I clicked on the home tab after making any change it took a while to open
the home screen. I'm not sure when this started but it was not a problem
several years ago. I finally tried eliminating everything except the Assets
and Liabilities Summary from the home screen and my problem was almost
entirely eliminated. Apparently it takes a while to recalculate all of the
data required if you have everything enabled on the home tab.

I hope this helps.

*
----
Brendan*


On Sun, Sep 29, 2013 at 10:38 AM, Joe W. Byers <ecjbosu at aol.com> wrote:

>  On 09/21/2013 10:02 AM, Joe W. Byers wrote:
>
> On 09/21/2013 09:52 AM, Alvaro Soliverez wrote:
>
> Hello Joe,
> 4.10 is probably the version of KDE, certainly not the version of KMyMoney.
> There should not be a significant degradation of performance, but
> knowing the exact version would help us find alternatives.
>
> We will probably require an anonymized file to work with. If you know
> how to save in anonymized format, that will help. Otherwise, let us
> know and we'll guide you through it.
>
> Regards,
> Alvaro
>
> On Sat, Sep 21, 2013 at 11:47 AM, Joe W. Byers <ecjbosu at aol.com> <ecjbosu at aol.com> wrote:
>
>  I have been using the kmyoney database with mysql for over 2 years now.  I
> have financial information back to 2000 in kmymoney.  I have seen a
> significant performance degradation the past year.  It takes minutes to load
> the data into the GUI at start up.
>
> I have the following questions:
> I was wondering if anyone else had this issue?
>
> I also would like to know how to close out past years and roll the net
> debit/credits to the opening balances, can this be done?
>
>
> I am using Kmymoney Platform Version 4.10.5 on the following system
> Linux FSEALHP1-linux.financialseal.com 3.9.10-100.fc17.x86_64 #1 SMP Sun Jul
> 14 01:31:27 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
>
> I am willing to work with developers on either of these questions.
>
> Thank you
> --
> Joe W. Byers
>
>
> _______________________________________________
> KMyMoney mailing listKMyMoney at kde.orghttps://mail.kde.org/mailman/listinfo/kmymoney
>
>  _______________________________________________
> KMyMoney mailing listKMyMoney at kde.orghttps://mail.kde.org/mailman/listinfo/kmymoney
>
>  Sorry about that, select the wrong About:
>
> Kmymoney: Version 4.6.2
>
> I have read about anomyzing, but not done it, so I will need some help.
>
> I have over 13K transactions.
>
> i have also created a working backup schema of my live data in the
> database.  I can create another test environment if needed.
>
> Thanks
> Joe
>
> PS is proper etiquette to reply at the bottom or top?
> --
> *Joe W. Byers*
>
>
> _______________________________________________
> KMyMoney mailing listKMyMoney at kde.orghttps://mail.kde.org/mailman/listinfo/kmymoney
>
>
> I have generated a anonmized xml file.  What do I need to do to test
> database performance?
>
> Thanks
> --
> *Joe W. Byers*
>
> _______________________________________________
> KMyMoney mailing list
> KMyMoney at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20130929/d275c1eb/attachment.html>