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

Reply via email to