Author: taylor Date: Tue May 26 01:22:00 2015 New Revision: 1681671 URL: http://svn.apache.org/r1681671 Log: JS2-1325: add index for performance improvement looking up by userid. make preference performance enhancement optional
Modified: portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/ddl-schema/registry-schema.xml portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/conf/jetspeed/jetspeed.properties Modified: portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/ddl-schema/registry-schema.xml URL: http://svn.apache.org/viewvc/portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/ddl-schema/registry-schema.xml?rev=1681671&r1=1681670&r2=1681671&view=diff ============================================================================== --- portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/ddl-schema/registry-schema.xml (original) +++ portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/ddl-schema/registry-schema.xml Tue May 26 01:22:00 2015 @@ -417,8 +417,11 @@ limitations under the License. <unique-column name="ENTITY_ID"/> <unique-column name="USER_NAME"/> <unique-column name="NAME"/> - </unique> - + </unique> + <index name="IX_USER_PREFERENCE"> + <index-column name="DTYPE"/> + <index-column name="USER_NAME"/> + </index> </table> <table name="PORTLET_PREFERENCE_VALUE"> Modified: portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/conf/jetspeed/jetspeed.properties URL: http://svn.apache.org/viewvc/portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/conf/jetspeed/jetspeed.properties?rev=1681671&r1=1681670&r2=1681671&view=diff ============================================================================== --- portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/conf/jetspeed/jetspeed.properties (original) +++ portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/conf/jetspeed/jetspeed.properties Tue May 26 01:22:00 2015 @@ -419,3 +419,9 @@ jetui.style.layout = .portal-layout-colu jetui.style.drag.handle = .PTitle # redirect to home space on login jetui.redirect.home.space=true + +#------------------------------------------------------------------------- +# Preferences Performance caching +# since 2.3.0 +#------------------------------------------------------------------------- +preferences.session.cache.enabled = true --------------------------------------------------------------------- To unsubscribe, e-mail: jetspeed-dev-unsubscr...@portals.apache.org For additional commands, e-mail: jetspeed-dev-h...@portals.apache.org