<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 09/21/2013 10:02 AM, Joe W. Byers
wrote:<br>
</div>
<blockquote cite="mid:523DB513.4070902@aol.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<div class="moz-cite-prefix">On 09/21/2013 09:52 AM, Alvaro
Soliverez wrote:<br>
</div>
<blockquote
cite="mid:CAMJ2LZ5rxfRKzWQtiXfhex3vS0rjHjfr=spoEJ1v_UOywr-aLw@mail.gmail.com"
type="cite">
<pre wrap="">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 moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="mailto:ecjbosu@aol.com"><ecjbosu@aol.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:KMyMoney@kde.org">KMyMoney@kde.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="https://mail.kde.org/mailman/listinfo/kmymoney">https://mail.kde.org/mailman/listinfo/kmymoney</a>
</pre>
</blockquote>
<pre wrap="">_______________________________________________
KMyMoney mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:KMyMoney@kde.org">KMyMoney@kde.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="https://mail.kde.org/mailman/listinfo/kmymoney">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 class="moz-signature">-- <br>
<b>Joe W. Byers</b><br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
KMyMoney mailing list
<a class="moz-txt-link-abbreviated" href="mailto:KMyMoney@kde.org">KMyMoney@kde.org</a>
<a class="moz-txt-link-freetext" href="https://mail.kde.org/mailman/listinfo/kmymoney">https://mail.kde.org/mailman/listinfo/kmymoney</a>
</pre>
</blockquote>
<br>
I have generated a anonmized xml file. What do I need to do to test
database performance?<br>
<br>
Thanks<br>
<div class="moz-signature">-- <br>
<b>Joe W. Byers</b><br>
</div>
</body>
</html>