[Treebase-guts] [ treebase-Bugs-2899241 ] Performance checking

[SourceForge.net <no...@so...>]

Bugs item #2899241, was opened at 2009-11-17 17:18
Message generated for change (Comment added) made by rvos
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1126676&aid=2899241&group_id=248804

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: performance
Group: None
>Status: Closed
Priority: 9
Private: No
Submitted By: Rutger Vos (rvos)
Assigned to: Rutger Vos (rvos)
Summary: Performance checking

Initial Comment:
Goal: to develop, implement and execute a strategy for recording performance differences (if any) between DB2 and PostgreSQL. 

----------------------------------------------------------------------

>Comment By: Rutger Vos (rvos)
Date: 2009-12-17 13:53

Message:
I summarized the benchmarking comparison. Here's what I did:

* collected all matrix, study and tree IDs

* wrote a perl script that fetches the PhyloWS URL for each data type,
for each ID, for each server and recorded response time

* wrote out the results in the attached files (e.g MATRICES.sdsc lists
the response time in seconds for each matrix when downloaded from
8ball.sdsc.edu)

* joined the equivalent files for both servers (e.g. $ join
MATRICES.sdsc MATRICES.nescent > MATRICES.joined)

* created box plots, which are the attached pdfs

Conclusions: for pages where the main effort lies in tomcat returning
JSPs (i.e. for studies and trees), NESCent outperforms SDSC (this is
after I assigned more memory to tomcat). For pages where the main
effort lies in the database returning data, SDSC (DB2) outperforms
NESCent (postgres) by about 30%. The low hanging fruit for further
optimization seems to be the database, not the servlet container.

----------------------------------------------------------------------

Comment By: Rutger Vos (rvos)
Date: 2009-12-17 13:53

Message:
Your bug has been resolved.  Thanks for the report.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1126676&aid=2899241&group_id=248804