Cache_Lite, Cache, Zend_Cache, etc are all examples of caching layers that can reduce the cost of repeated queries on infrequently changing data.
It'd be good to benchmark actions on the site and either cache some calls or avoid queries unless absolutely needed, so that performance remains fairly acceptable.
At the moment, loading the list view takes a number of seconds if postgres has not queried that data recently.
Cache_Lite, Cache, Zend_Cache, etc are all examples of caching layers that can reduce the cost of repeated queries on infrequently changing data.
It'd be good to benchmark actions on the site and either cache some calls or avoid queries unless absolutely needed, so that performance remains fairly acceptable.
At the moment, loading the list view takes a number of seconds if postgres has not queried that data recently.