[Kmymoney] Database Performance Issue

[Joe W. Byers]

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*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20130921/ba7c3610/attachment.html>