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 -N -r1.150.2.20 -r1.150.2.21 --- openacs-4/packages/acs-kernel/acs-kernel.info 4 Sep 2019 16:43:09 -0000 1.150.2.20 +++ openacs-4/packages/acs-kernel/acs-kernel.info 15 Nov 2019 14:43:09 -0000 1.150.2.21 @@ -9,15 +9,15 @@ f t - + OpenACS Core Team Routines and data models providing the foundation for OpenACS-based Web services. 2017-08-06 OpenACS The OpenACS kernel contains the core datamodel create and drop scripts for such things as objects, groups, parties and the supporting PL/SQL and PL/pgSQL procedures. 3 - + 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 -N -r1.71.2.3 -r1.71.2.4 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql 3 Sep 2019 09:09:16 -0000 1.71.2.3 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql 15 Nov 2019 14:43:09 -0000 1.71.2.4 @@ -253,7 +253,9 @@ -- create index acs_objects_context_object_idx onacs_objects (context_id, object_id); create index acs_objects_creation_user_idx on acs_objects (creation_user); +create index acs_objects_creation_date_idx on acs_objects (creation_date); create index acs_objects_modify_user_idx on acs_objects (modifying_user); +create index acs_objects_last_modified_idx on acs_objects (last_modified); create index acs_objects_package_idx on acs_objects (package_id); create index acs_objects_title_idx on acs_objects(title); Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0d23-5.10.0d24.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/Attic/upgrade-5.10.0d23-5.10.0d24.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0d23-5.10.0d24.sql 15 Nov 2019 14:43:09 -0000 1.1.2.1 @@ -0,0 +1,4 @@ + +-- Create an index on these acs_object metadata +create index acs_objects_creation_date_idx on acs_objects (creation_date); +create index acs_objects_last_modified_idx on acs_objects (last_modified);