ets-berkeley-edu/calcentral — pull request #53 by ctweney (2012-09-14 17:40:23+00:00)
Title: CLC-164 Improving ClassPage API performance

3 main changes:

1) Add commons-dbcp connection pooling (for all datasources, not just campus oracle)

2) Get list of sections and their instructors in a single query for the whole course (instead of 1 query per section).

3) Tune getCourseInstructors query by rewriting its join. This cut the query from 1500ms to about 30ms.

The Telemetry class may be useful in the future. I can turn down its log level if it seems too noisy.