[Kmymoney] SQL debug

[Phil Richardson]

Thanks for the response Christian,

That's interesting to hear that Git master has improvements. Due to
requirements, I'm not going to be able to use that in a production way, or
even for serious testing. Though, I will spool up an VM and have a look at
least.

I'll explore the reduction in the redundant operations as well and let you
know how they feel in comparison.

On 25 April 2015 at 19:39, Christian Dávid <christian-david at web.de> wrote:

> Hello Phil,
>
> sorry for my late answer. I hope this is still of interest for you.
>
> The current git master contains several changes which improve the SQL
> back-end.
> You should really use that as some of the redundant calls are removed by
> now.
> Also the start up should be faster (if you know who much, please tell me!).
>
> Some redundant calls cannot be prevented. Even if KMyMoney does not
> support it
> at the moment, it should be able to handle multiple users working with the
> same database in future. In that scenario the calls may be needed.
>
> The other problem is that the SQL back-end is everything but not straight
> forward. It is really hard to see for a developer where redundant calls are
> from and how to solve them.
>
> Hope you are still working on this!
>
> Greetings
> Christian
>
> Am Montag, 16. Februar 2015, 14:25:36 schrieb Phil Richardson:
> > I am currently on kmymoney 4.6.6. Although an older build, I have
> explored
> > what has been done in the code areas that could impact what I describe.
> >
> > I do intend to update, but this requires a few other operating systems to
> > be updated first (Ubuntu deps issue), but I don't see anything at the
> code
> > side that would indicate such an advantage that I should hold out on
> > providing this detail.
> […]
> > I am currently trying to explore the startup sequence and timings when
> > using kmymoney with a MySQL server.
> […]
> > For one, there is a shed load of MySQL data in the startup seq. Looking
> at
> > the code, there are plenty of calls. Looking at the SELECTS that occur,
> the
> > are lot redundant operations.
>
> _______________________________________________
> KMyMoney mailing list
> KMyMoney at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20150425/bfa2944e/attachment.html>