Index: openacs-4/packages/acs-kernel/acs-kernel.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v
diff -u -r1.101 -r1.102
--- openacs-4/packages/acs-kernel/acs-kernel.info	12 Feb 2009 02:27:02 -0000	1.101
+++ openacs-4/packages/acs-kernel/acs-kernel.info	13 Feb 2009 13:36:02 -0000	1.102
@@ -7,15 +7,15 @@
     <initial-install-p>t</initial-install-p>
     <singleton-p>t</singleton-p>
     
-    <version name="5.5.0d5" url="http://openacs.org/repository/download/apm/acs-kernel-5.5.0d5.apm">
+    <version name="5.5.0d6" url="http://openacs.org/repository/download/apm/acs-kernel-5.5.0d6.apm">
         <owner url="mailto:oct@openacs.org">OpenACS Core Team</owner>
         <summary>Routines and data models providing the foundation for OpenACS-based Web services.</summary>
         <release-date>2008-05-31</release-date>
         <vendor url="http://openacs.org">OpenACS</vendor>
         <description format="text/html">The OpenACS kernel contains the core datamodel create and drop scripts for such things as objects, groups, partiies and the supporting PL/SQL and PL/pgSQL procedures.</description>
         <maturity>3</maturity>
 
-        <provides url="acs-kernel" version="5.5.0d5"/>
+        <provides url="acs-kernel" version="5.5.0d6"/>
 
         <callbacks>
         </callbacks>
Index: openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql,v
diff -u -r1.21 -r1.22
--- openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql	18 Aug 2006 18:17:49 -0000	1.21
+++ openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql	13 Feb 2009 13:36:02 -0000	1.22
@@ -151,8 +151,8 @@
 	unique (context_id, object_id) disable
 );
 
-create index acs_objects_context_object_idx on
-       acs_objects (context_id, object_id);
+create index acs_objects_context_object_idx on acs_objects (context_id, object_id);
+create index acs_obj_ctx_idx_object_id_idx on acs_object_context_index (object_id);
 
 alter table acs_objects modify constraint acs_objects_context_object_un enable;
 
Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.5.0d5-5.5.0d6.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.5.0d5-5.5.0d6.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.5.0d5-5.5.0d6.sql	13 Feb 2009 13:36:02 -0000	1.1
@@ -0,0 +1 @@
+create index acs_obj_ctx_idx_object_id_idx on acs_object_context_index (object_id);
Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql,v
diff -u -r1.57 -r1.58
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql	17 Sep 2007 09:43:56 -0000	1.57
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql	13 Feb 2009 13:36:02 -0000	1.58
@@ -411,6 +411,7 @@
 );
 
 create index acs_obj_ctx_idx_ancestor_idx on acs_object_context_index (ancestor_id);
+create index acs_obj_ctx_idx_object_id_idx on acs_object_context_index (object_id);
 
 create view acs_object_paths
 as select object_id, ancestor_id, n_generations
Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql,v
diff -u -r1.32 -r1.33
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql	14 May 2007 20:30:21 -0000	1.32
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql	13 Feb 2009 13:36:02 -0000	1.33
@@ -71,6 +71,13 @@
 
 create index acs_priv_desc_map_idx on acs_privilege_descendant_map(descendant);
 
+-- Gustaf (Jan 2009): interesting enough, the index above is never
+-- used on openacs.org and can be most likely dropped. The index below
+-- (together with acs_obj_ctx_idx_object_id_idx) makes real-world
+-- applications more than a factor of 10 faster (openacs/download and
+-- openacs/download/one-revision?revision_id=2089636)
+create index acs_priv_desc_map_privilege_idx on acs_privilege_descendant_map (privilege);
+
 -- This trigger is used to create a pseudo-tree hierarchy that
 -- can be used to emulate tree queries on the acs_privilege_hierarchy table.
 -- The acs_privilege_hierarchy table maintains the permissions structure, but 
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.5.0d5-5.5.0d6.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.5.0d5-5.5.0d6.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.5.0d5-5.5.0d6.sql	13 Feb 2009 13:36:02 -0000	1.1
@@ -0,0 +1,2 @@
+create index acs_obj_ctx_idx_object_id_idx on acs_object_context_index (object_id);
+create index acs_priv_desc_map_privilege_idx on acs_privilege_descendant_map (privilege);