<div dir="ltr">J<div class="gmail_default" style="font-family:'courier new',monospace;color:rgb(7,55,99);display:inline">oe,</div><div><div class="gmail_default" style="font-family:'courier new',monospace;color:rgb(7,55,99);display:inline">
<br></div></div><div><div class="gmail_default" style="font-family:'courier new',monospace;color:rgb(7,55,99);display:inline">I'm not a developer but I thought I'd share my experience on the off chance it will help you.</div>
</div><div><div class="gmail_default" style="font-family:'courier new',monospace;color:rgb(7,55,99);display:inline"><br></div></div><div><div class="gmail_default" style="font-family:'courier new',monospace;color:rgb(7,55,99);display:inline">
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).</div></div><div><div class="gmail_default" style="font-family:'courier new',monospace;color:rgb(7,55,99);display:inline">
<br></div></div><div><div class="gmail_default" style="font-family:'courier new',monospace;color:rgb(7,55,99);display:inline">I have over 10,000 transactions.</div></div><div><div class="gmail_default" style="font-family:'courier new',monospace;color:rgb(7,55,99);display:inline">
<br></div></div><div><div class="gmail_default" style="font-family:'courier new',monospace;color:rgb(7,55,99);display:inline">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?</div>
</div><div><div class="gmail_default" style="font-family:'courier new',monospace;color:rgb(7,55,99);display:inline"><br></div></div><div><div class="gmail_default" style="font-family:'courier new',monospace;color:rgb(7,55,99)">
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.</div>
<div class="gmail_default" style="font-family:'courier new',monospace;color:rgb(7,55,99)"><br></div></div><div><div class="gmail_default" style="font-family:'courier new',monospace;color:rgb(7,55,99)">I hope this helps.</div>
</div></div><div class="gmail_extra"><br clear="all"><div><div dir="ltr"><font face="tahoma, sans-serif" color="#073763"><b><br>----<br>Brendan</b></font><br></div></div>
<br><br><div class="gmail_quote">On Sun, Sep 29, 2013 at 10:38 AM, Joe W. Byers <span dir="ltr"><<a href="mailto:ecjbosu@aol.com" target="_blank">ecjbosu@aol.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"><div><div class="h5">
<div>On 09/21/2013 10:02 AM, Joe W. Byers
wrote:<br>
</div>
<blockquote type="cite">
<div>On 09/21/2013 09:52 AM, Alvaro
Soliverez wrote:<br>
</div>
<blockquote type="cite">
<pre>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 <a href="mailto:ecjbosu@aol.com" target="_blank"><ecjbosu@aol.com></a> wrote:
</pre>
<blockquote type="cite">
<pre>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 <a href="http://FSEALHP1-linux.financialseal.com" target="_blank">FSEALHP1-linux.financialseal.com</a> 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
<a href="mailto:KMyMoney@kde.org" target="_blank">KMyMoney@kde.org</a>
<a href="https://mail.kde.org/mailman/listinfo/kmymoney" target="_blank">https://mail.kde.org/mailman/listinfo/kmymoney</a>
</pre>
</blockquote>
<pre>_______________________________________________
KMyMoney mailing list
<a href="mailto:KMyMoney@kde.org" target="_blank">KMyMoney@kde.org</a>
<a href="https://mail.kde.org/mailman/listinfo/kmymoney" target="_blank">https://mail.kde.org/mailman/listinfo/kmymoney</a>
</pre>
</blockquote>
Sorry about that, select the wrong About:<br>
<br>
Kmymoney: Version 4.6.2<br>
<br>
I have read about anomyzing, but not done it, so I will need some
help.<br>
<br>
I have over 13K transactions.<br>
<br>
i have also created a working backup schema of my live data in the
database. I can create another test environment if needed.<br>
<br>
Thanks <br>
Joe<br>
<br>
PS is proper etiquette to reply at the bottom or top?<br>
<div>-- <br>
<b>Joe W. Byers</b><br>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
KMyMoney mailing list
<a href="mailto:KMyMoney@kde.org" target="_blank">KMyMoney@kde.org</a>
<a href="https://mail.kde.org/mailman/listinfo/kmymoney" target="_blank">https://mail.kde.org/mailman/listinfo/kmymoney</a>
</pre>
</blockquote>
<br></div></div>
I have generated a anonmized xml file. What do I need to do to test
database performance?<br>
<br>
Thanks<span class="HOEnZb"><font color="#888888"><br>
<div>-- <br>
<b>Joe W. Byers</b><br>
</div>
</font></span></div>
<br>_______________________________________________<br>
KMyMoney mailing list<br>
<a href="mailto:KMyMoney@kde.org">KMyMoney@kde.org</a><br>
<a href="https://mail.kde.org/mailman/listinfo/kmymoney" target="_blank">https://mail.kde.org/mailman/listinfo/kmymoney</a><br>
<br></blockquote></div><br></div>