We have a couple of performance issues due to not caching information that is cachable. Here is a list of what I found out when doing performance tuning for assessment:
- get_table_name (DB Call in CR). This query is executed on every insert of an item and on various other occassions. It returns the table_name associated with an acs_object_type. According to my understanding, you cannot (better maybe: should not) change the table_name associated with an acs_object_type without restarting the server (read: Upgrade).
- package_object_attribute_list (ACS-Subsite Package Procs). Same here, the query retrieves a list of attributes for a specific object_type, which shouldn't change either unless your restart your server.
Do I need to TIP either of these changes? Should I write a general TIP to allow performance changes that allow the use of util_memoize on all db_queries that return values that are not supposed to change without a restart of the server?
