ieb/sparsemapcontent — Issue #157: Support caching on queries relating to children.
Author: ieb
Created: 2012-02-03 00:15:28+00:00
State: open

At the moment, to ask what children there are we go to storage to get a list of IDs. https://uisapp2.iu.edu/confluence-prd/download/attachments/141066770/2012-02-02+load+testing+Database+Executions.png?version=1&modificationDate=1328201350485 shows that this is done on average 3 times per request consuming 6ms per request.

Also:
The load test above is not using the fix to authorizable caching hence why there is an almost 1:1 relationship between the "validate connection query select 1 from DUAL" performed when the sparse jdbc client is taken out of the pool (NB there was a bug causing pooling to fail in the version of code running so tehre is a 1:1 relationship between that query and the requests serviced).

Upgrading to the latest sparse should reduce all the other queries to cached.