[Kmymoney] Database Performance Issue

[Joe W. Byers]

On 09/29/2013 11:08 PM, Brendan Coupe wrote:
> 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 
> <mailto: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>  <mailto: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
>>>>     LinuxFSEALHP1-linux.financialseal.com  <http://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 list
>>>>     KMyMoney at kde.org  <mailto:KMyMoney at kde.org>
>>>>     https://mail.kde.org/mailman/listinfo/kmymoney
>>>>
>>>     _______________________________________________
>>>     KMyMoney mailing list
>>>     KMyMoney at kde.org  <mailto:KMyMoney at kde.org>
>>>     https://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 list
>>     KMyMoney at kde.org  <mailto:KMyMoney at kde.org>
>>     https://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 <mailto:KMyMoney at kde.org>
>     https://mail.kde.org/mailman/listinfo/kmymoney
>
>
Brendan,

I use the database and want to use the DB.  My performance issues are 
the same that you see, slow to load, slow to move around, and slow to 
move again after changes.  I will try you suggestion to remove things 
from the home screen.

This sounds reasonable, because in my experience with other systems, 
performance degrades as calculations added.


Thanks
Joe


-- 
*Joe W. Byers*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20130930/a13bba63/attachment.html>