KMyMoney 1.0.1 + Database: poor performance

[Juan Antonio Mariano]

Hello everybody:

I am running KMyMoney 1.0.1 (KDE 3.5.10) on Ubuntu 9.04. I am using the
database feature (MySQL3) and, so far, it works great. We are even using
it concurrently (my wife and me), and it works fine!!!

The problem I'm finding on recent times is that performance is starting
to be poor. When I open the app it starts checking for scheduled
transactions and it takes a very long time, not responding, checking
(and entering, if applicable) those transactions (and I have in total
less than 20 monthly schedules, not a big deal).

The same applies to reconciling accounts, and now even when I try to go
to back to the Accounts main page from any other part, it starts to take
some time (maybe like 15 or 20 seconds) to show me that page.

By the way, I have just moved from Windows + MS Money, so I'm still new
to Linux, and far from being an expert. Very, very, very far :):):).

Any ideas on where should I start looking?

Thanks in advance,

Juan.


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

Hello Juan,
the database performance is behind compared to the file.
How much is a long time? 1 minute? 20 seconds? 10 minutes?

The database developers have been working on improving performance, but it's obviously behind using a file, because in that case the file is loaded into RAM and worked from there.

Regards,
Alvaro

On Sat, Nov 7, 2009 at 8:42 AM, Juan Antonio Mariano <jamariano@...> wrote:

Hello everybody:

I am running KMyMoney 1.0.1 (KDE 3.5.10) on Ubuntu 9.04. I am using the
database feature (MySQL3) and, so far, it works great. We are even using
it concurrently (my wife and me), and it works fine!!!

The problem I'm finding on recent times is that performance is starting
to be poor. When I open the app it starts checking for scheduled
transactions and it takes a very long time, not responding, checking
(and entering, if applicable) those transactions (and I have in total
less than 20 monthly schedules, not a big deal).

The same applies to reconciling accounts, and now even when I try to go
to back to the Accounts main page from any other part, it starts to take
some time (maybe like 15 or 20 seconds) to show me that page.

By the way, I have just moved from Windows + MS Money, so I'm still new
to Linux, and far from being an expert. Very, very, very far :):):).

Any ideas on where should I start looking?

Thanks in advance,

Juan.


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

[Juan Antonio Mariano]

Hi Alvaro:

when I open the app and it starts checking for scheduled transactions, it may take up to 4 or 5 minutes. Otherwise, by "long time" (for example, returning to the accounts page), it really means like 10 to 15 seconds. But that time is increasing everyday (it was really fast a couple of weeks ago).

I understand that with a file it is faster (for the moment), but I love the possibility of working both my wife and me at the same time, updating different accounts, from 2 different computers.

Is there anyway in which I can help with this functionality? (Testing, I'm not really into wrinting code ).

Best regards,

Juan.


Alvaro Soliverez escribió:

Hello Juan,
the database performance is behind compared to the file.
How much is a long time? 1 minute? 20 seconds? 10 minutes?

The database developers have been working on improving performance, but it's obviously behind using a file, because in that case the file is loaded into RAM and worked from there.

Regards,
Alvaro

On Sat, Nov 7, 2009 at 8:42 AM, Juan Antonio Mariano <jamariano@...> wrote:

Hello everybody:

I am running KMyMoney 1.0.1 (KDE 3.5.10) on Ubuntu 9.04. I am using the
database feature (MySQL3) and, so far, it works great. We are even using
it concurrently (my wife and me), and it works fine!!!

The problem I'm finding on recent times is that performance is starting
to be poor. When I open the app it starts checking for scheduled
transactions and it takes a very long time, not responding, checking
(and entering, if applicable) those transactions (and I have in total
less than 20 monthly schedules, not a big deal).

The same applies to reconciling accounts, and now even when I try to go
to back to the Accounts main page from any other part, it starts to take
some time (maybe like 15 or 20 seconds) to show me that page.

By the way, I have just moved from Windows + MS Money, so I'm still new
to Linux, and far from being an expert. Very, very, very far :):):).

Any ideas on where should I start looking?

Thanks in advance,

Juan.


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

[Fernando Vilas-2]

On Saturday 07 November 2009 14:05:56 Juan Antonio Mariano wrote:

>  Hi Alvaro:
>
>  when I open the app and it starts checking for scheduled transactions, it
>  may take up to 4 or 5 minutes. Otherwise, by "long time" (for example,
>  returning to the accounts page), it really means like 10 to 15 seconds.
>  But that time is increasing everyday (it was really fast a couple of weeks
>  ago).
>
>  I understand that with a file it is faster (for the moment), but I love
>  the possibility of working both my wife and me at the same time, updating
>  different accounts, from 2 different computers.
>
>  Is there anyway in which I can help with this functionality? (Testing, I'm
>  not really into wrinting code ).
>
>  Best regards,
>
>  Juan.
>

[...]

Juan,

        Thanks for reporting. The poor performance of the database backend is a known
issue. We decided to just live with it being slow until the KDE4 port. There
are some features in Qt4 that will help speed things up that we will be
phasing in. There has been some progress made on that already, but there is
much more to go. Unfortunately, the features that let us gain more speed are
(mostly) incompatible with Qt3, so it means that the speed improvements are
unlikely to be backported.

        As far as testing, there is a way to get an analysis file listing the
functions where the computer is spending the most time, and why. That's my
main tool for figuring out where to tweak the database code for speed, but I
only have profiles from my own computers. Once the KDE4 port is stable enough
for beta, I can give you instructions on how to create this file. Don't worry,
there is no personal information in it. That way, I can get a picture of how
people are using the database code to make things better for them. Right now,
my main areas of focus for improving the speed are in startup time and
statement import time.

        Lastly, the idea of multiple simultaneous users is attractive, but currently
unsupported. We have made efforts to make the data consistent even when there
are multiple users, but it is untested and leads to the possibility of subtle
data corruption. That is why there is a warning if you open the database while
another user has it open. I really do not advise ignoring this warning.

--
Thanks,
Fernando Vilas
fvilas@...


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user