svn commit: r1681671 - in /portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main: ddl-schema/registry-schema.xml resources/conf/jetspeed/jetspeed.properties

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