[Kmymoney] Database Performance Issue

[Joe W. Byers]

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>  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 list
>>> KMyMoney at kde.org
>>> https://mail.kde.org/mailman/listinfo/kmymoney
>>>
>> _______________________________________________
>> KMyMoney mailing list
>> 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
> 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*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20130929/d6cf045d/attachment.html>