[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mifos-developer
Subject:    Re: [Mifos-developer] Need the community help in improving Mifos
From:       Jakub Sławiński <jslawinski () soldevelo ! com>
Date:       2011-08-29 17:07:09
Message-ID: 4E5BC73D.3060107 () soldevelo ! com
[Download RAW message or body]


Hi Udai,

I also enabled the following setting:
log-queries-not-using-indexes

Regarding this Java slowness, it might be caused by the GC, because it
only appears after some time from starting tomcat (but I can always
reproduce it after displaying less than 20-30 clients). When it appears
for the first time, it is visible quite frequently.

The second cause might be the implementation of the
clientPerformanceHistory.getDelinquentPortfolioAmount() method, because
this method is usually a problem (sometimes it takes only 100 ms,
sometimes 2000 ms). Maybe it only takes a long time for the clients with
a big number of accounts with a big number of past instalments?


Regards,
  Jakub.

On 29.08.2011 18:38, Udai Gupta wrote:
> Jakub,
> 
> Let's suppose code (not sure about this yet) is performing bad and not
> the queries, in that case database size should not matter at all. But,
> we can not see that is happening with small database sizes. Why?
> 
> And if we can that I would agree that we have fix the code for better
> performance.
> 
> @logs, you have pasted queries which executes in milisecs, how is it
> slow query log? what was your slow query limit configuration?
> 
> Anyway, I am just trying to understand that if queries doesn't play
> major role in delay then it must be code and should be very much
> visible as database size will not be factor anymore.
> 
> Is it more delay with more users logged in, Could it be threading problem?
> 
> May be something like Spring Insight tool will be able to give more
> data on performance.
> 
> Udai
> 
> ------------------------------------------------------------------------------
> EMC VNX: the world's simplest storage, starting under $10K
> The only unified storage solution that offers unified management 
> Up to 160% more powerful than alternatives and 25% more efficient. 
> Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
> Mifos-developer mailing list
> mifos-developer@lists.sourceforge.net
> Unsubscribe or change settings at:
> https://lists.sourceforge.net/lists/listinfo/mifos-developer


------------------------------------------------------------------------------
EMC VNX: the world's simplest storage, starting under $10K
The only unified storage solution that offers unified management 
Up to 160% more powerful than alternatives and 25% more efficient. 
Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
Mifos-developer mailing list
mifos-developer@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer
[prev in list] [next in list] [prev in thread] [next in thread]