Notes on current (May 2008) performance issues at Grameen Koota.
clicks amp reports against testblue v1.0,large (based on GK prod),closest to gk prod,successful repro clicks & reports against testgreen,v1.0,minimal,would be easier to test,no repro clicks against testblue while executing reports manually as SQL scripts,v1.0,large (based on GK prod),to isolate problem to ReportsConnectionPool,TBD "clicks & reports against testblue; different JBoss, MySQL, or Java versions",v1.0,large (based on GK prod),look for problems in rest of Mifos stack,TBD only clicks against testgreen,v1.1,large (based on GK prod),TBD,TBD clicks & reports against testgreen,v1.1,large (based on GK prod),TBD,TBD clicks & reports against testgreen,v1.1,minimal,TBD,TBD
Brainstorm stopgap fixes here.
Session.close()
is always calledjasper.pool.size
ReportsConnectionPool
with DBCP (Adam Feuer)jasper.pool.size
db connection config setting
show status
Brainstorm starting points for more in-depth fixes here.