Author: cmailleux
Date: Wed Jun 20 09:18:44 2007
New Revision: 17656
URL: https://svndev.jahia.net/websvn/listing.php?sc=3D1&rev=3D17656&repname=
=3Djahia
Log:
Add index on jahia fields data for boosting performance when searching meta=
data by workflow_state
Modified:
branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
hypersonic/jahia-schema-index.sql
branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mssql/jahia-schema-index.sql
branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mysql-tx/jahia-schema-index.sql
branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mysql/jahia-schema-index.sql
branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
oracle/jahia-schema-index.sql
branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
postgresql/jahia-schema-index.sql
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/hypersonic/jahia-schema-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/hypersonic/jahia-schema-i=
ndex.sql&rev=3D17656&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
hypersonic/jahia-schema-index.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
hypersonic/jahia-schema-index.sql Wed Jun 20 09:18:44 2007
@@ -54,6 +54,8 @@
=
DROP INDEX jahia_fields_data_index13 ON jahia_fields_data ;
=
+DROP INDEX jahia_fields_data_index14 ON jahia_fields_data ;
+
DROP INDEX jahia_fields_def_index ON jahia_fields_def ;
=
DROP INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop ;
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/mssql/jahia-schema-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/mssql/jahia-schema-index.=
sql&rev=3D17656&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mssql/jahia-schema-index.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mssql/jahia-schema-index.sql Wed Jun 20 09:18:44 2007
@@ -54,6 +54,8 @@
=
DROP INDEX jahia_fields_data_index13 ON jahia_fields_data ;
=
+DROP INDEX jahia_fields_data_index14 ON jahia_fields_data ;
+
DROP INDEX jahia_fields_def_index ON jahia_fields_def ;
=
DROP INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop ;
@@ -162,6 +164,8 @@
=
CREATE INDEX jahia_fields_data_index13 ON jahia_fields_data (id_jahia_fiel=
ds_data, workflow_state,language_code);
=
+CREATE INDEX jahia_fields_data_index14 ON jahia_fields_data (id_jahia_obj,=
type_jahia_obj, workflow_state);
+
CREATE INDEX jahia_fields_def_index ON jahia_fields_def (name_jahia_fields=
_def);
=
CREATE INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop (flddefi=
d_jahia_fields_def_prop);
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/mysql-tx/jahia-schema-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/mysql-tx/jahia-schema-ind=
ex.sql&rev=3D17656&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mysql-tx/jahia-schema-index.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mysql-tx/jahia-schema-index.sql Wed Jun 20 09:18:44 2007
@@ -54,6 +54,8 @@
=
DROP INDEX jahia_fields_data_index13 ON jahia_fields_data ;
=
+DROP INDEX jahia_fields_data_index14 ON jahia_fields_data ;
+
DROP INDEX jahia_fields_def_index ON jahia_fields_def ;
=
DROP INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop ;
@@ -160,6 +162,8 @@
=
CREATE INDEX jahia_fields_data_index13 ON jahia_fields_data (id_jahia_fiel=
ds_data, workflow_state,language_code);
=
+CREATE INDEX jahia_fields_data_index14 ON jahia_fields_data (id_jahia_obj,=
type_jahia_obj, workflow_state);
+
CREATE INDEX jahia_fields_def_index ON jahia_fields_def (name_jahia_fields=
_def);
=
CREATE INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop (flddefi=
d_jahia_fields_def_prop);
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/mysql/jahia-schema-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/mysql/jahia-schema-index.=
sql&rev=3D17656&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mysql/jahia-schema-index.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mysql/jahia-schema-index.sql Wed Jun 20 09:18:44 2007
@@ -54,6 +54,8 @@
=
DROP INDEX jahia_fields_data_index13 ON jahia_fields_data ;
=
+DROP INDEX jahia_fields_data_index14 ON jahia_fields_data ;
+
DROP INDEX jahia_fields_def_index ON jahia_fields_def ;
=
DROP INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop ;
@@ -162,6 +164,8 @@
=
CREATE INDEX jahia_fields_data_index13 ON jahia_fields_data (id_jahia_fiel=
ds_data, workflow_state,language_code);
=
+CREATE INDEX jahia_fields_data_index14 ON jahia_fields_data (id_jahia_obj,=
type_jahia_obj, workflow_state);
+
CREATE INDEX jahia_fields_def_index ON jahia_fields_def (name_jahia_fields=
_def);
=
CREATE INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop (flddefi=
d_jahia_fields_def_prop);
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/oracle/jahia-schema-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/oracle/jahia-schema-index=
.sql&rev=3D17656&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
oracle/jahia-schema-index.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
oracle/jahia-schema-index.sql Wed Jun 20 09:18:44 2007
@@ -50,6 +50,8 @@
=
DROP INDEX jahia_fields_data_index13;
=
+DROP INDEX jahia_fields_data_index14;
+
DROP INDEX jahia_fields_def_index;
=
DROP INDEX jahia_fields_def_prop_index;
@@ -147,6 +149,8 @@
=
CREATE INDEX jahia_fields_data_index13 ON jahia_fields_data (id_jahia_fiel=
ds_data, workflow_state,language_code);
=
+CREATE INDEX jahia_fields_data_index14 ON jahia_fields_data (id_jahia_obj,=
type_jahia_obj, workflow_state);
+
CREATE INDEX jahia_fields_def_index ON jahia_fields_def (name_jahia_fields=
_def);
=
CREATE INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop (flddefi=
d_jahia_fields_def_prop);
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/postgresql/jahia-schema-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-schema-i=
ndex.sql&rev=3D17656&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
postgresql/jahia-schema-index.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
postgresql/jahia-schema-index.sql Wed Jun 20 09:18:44 2007
@@ -54,6 +54,8 @@
=
DROP INDEX jahia_fields_data_index13;
=
+DROP INDEX jahia_fields_data_index14;
+
DROP INDEX jahia_fields_def_index;
=
DROP INDEX jahia_fields_def_prop_index;
@@ -162,6 +164,8 @@
=
CREATE INDEX jahia_fields_data_index13 ON jahia_fields_data (id_jahia_fiel=
ds_data, workflow_state,language_code);
=
+CREATE INDEX jahia_fields_data_index14 ON jahia_fields_data (id_jahia_obj,=
type_jahia_obj, workflow_state);
+
CREATE INDEX jahia_fields_def_index ON jahia_fields_def (name_jahia_fields=
_def);
=
CREATE INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop (flddefi=
d_jahia_fields_def_prop);
_______________________________________________
cvs_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/cvs_list
