RE: Index

Fri, 09 Sep 2005 01:47:07 -0700

Ok I use the index on the site exept the part with old version of jahia.

This seems good.

 

Thanks for your help.

 

Nicolas

 

PS :

 

Here is my script

 

CREATE INDEX id_jahia_acl_index ON jahia_acl (id_jahia_acl);

CREATE INDEX parent_id_jahia_acl_index ON jahia_acl (parent_id_jahia_acl);

CREATE INDEX id_jahia_fields_data_index ON jahia_fields_data (id_jahia_fields_data);

CREATE INDEX ctnid_jahia_fields_data_index ON jahia_fields_data (ctnid_jahia_fields_data);

CREATE INDEX pageid_jahia_fields_data_index ON jahia_fields_data (pageid_jahia_fields_data);

CREATE INDEX id_jahia_ctn_entries_index ON jahia_ctn_entries (id_jahia_ctn_entries);

CREATE INDEX pageid_jahia_ctn_entries_index ON jahia_ctn_entries (pageid_jahia_ctn_entries);

CREATE INDEX id_jahia_pages_data_index ON jahia_pages_data (id_jahia_pages_data);

CREATE INDEX parentid_jahia_pages_data_index ON jahia_pages_data (parentid_jahia_pages_data);

CREATE INDEX id_jahia_ctn_lists_index ON jahia_ctn_lists (id_jahia_ctn_lists);

CREATE INDEX pageid_jahia_ctn_lists_index ON jahia_ctn_lists (pageid_jahia_ctn_lists);

 

CREATE INDEX jahia_acl_index2 ON jahia_acl ( parent_id_jahia_acl,id_jahia_acl );

CREATE INDEX jahia_ctn_def_properties_index ON jahia_ctn_def_properties ( ctndefid_jahia_ctn_def_prop );

CREATE INDEX jahia_ctn_entries_index ON jahia_ctn_entries ( rights_jahia_ctn_entries );

CREATE INDEX jahia_ctn_entries_index2 ON jahia_ctn_entries ( id_jahia_ctn_entries,workflow_state );

CREATE INDEX jahia_ctn_entries_index3 ON jahia_ctn_entries ( pageid_jahia_ctn_entries,workflow_state );

CREATE INDEX jahia_ctn_entries_index4 ON jahia_ctn_entries ( listid_jahia_ctn_entries,workflow_state,rank_jahia_ctn_entries,id_jahia_ctn_entries );

CREATE INDEX jahia_ctn_entries_index5 ON jahia_ctn_entries ( id_jahia_ctn_entries,rights_jahia_ctn_entries );

CREATE INDEX jahia_ctn_lists_index ON jahia_ctn_lists ( id_jahia_ctn_lists,workflow_state );

CREATE INDEX jahia_ctn_lists_index2 ON jahia_ctn_lists (  parententryid_jahia_ctn_lists,pageid_jahia_ctn_lists );

CREATE INDEX jahia_ctn_lists_index3 ON jahia_ctn_lists ( id_jahia_ctn_lists, parententryid_jahia_ctn_lists );

CREATE index jahia_ctn_lists_index4 ON jahia_ctn_lists ( pageid_jahia_ctn_lists, ctndefid_jahia_ctn_lists );

CREATE INDEX jahia_ctn_lists_index5 ON jahia_ctn_lists ( parententryid_jahia_ctn_lists,id_jahia_ctn_lists );

CREATE INDEX jahia_ctnlists_prop_index ON jahia_ctnlists_prop ( ctnlistid_ctnlists_prop );

CREATE INDEX jahia_ctn_struct_index ON jahia_ctn_struct ( rank_jahia_ctn_struct,ctnsubdefid_jahia_ctn_struct );

CREATE index jahia_ctn_struct_index2 ON jahia_ctn_struct( objdefid_jahia_ctn_struct );

CREATE INDEX jahia_ctn_struct_index3 ON jahia_ctn_struct ( objtype_jahia_ctn_struct,objdefid_jahia_ctn_struct,ctnsubdefid_jahia_ctn_struct );

CREATE INDEX jahia_ctn_struct_index4 ON jahia_ctn_struct ( ctnsubdefid_jahia_ctn_struct,rank_jahia_ctn_struct );

CREATE INDEX jahia_fields_data_index ON jahia_fields_data ( pageid_jahia_fields_data,workflow_state,ctnid_jahia_fields_data);

CREATE INDEX jahia_fields_data_index2 ON jahia_fields_data ( id_jahia_fields_data,workflow_state,ctnid_jahia_fields_data );

CREATE INDEX jahia_fields_data_index3 ON jahia_fields_data ( id_jahia_fields_data,workflow_state,pageid_jahia_fields_data );

CREATE INDEX jahia_fields_data_index4 ON jahia_fields_data ( id_jahia_fields_data,pageid_jahia_fields_data,ctnid_jahia_fields_data );

CREATE INDEX jahia_fields_data_index5 ON jahia_fields_data ( rights_jahia_fields_data );

CREATE INDEX jahia_fields_data_index6 ON jahia_fields_data ( ctnid_jahia_fields_data, rank_jahia_fields_data,id_jahia_fields_data);

CREATE INDEX jahia_fields_data_index7 ON jahia_fields_data ( value_jahia_fields_data,type_jahia_fields_data,workflow_state,version_id );

CREATE INDEX jahia_fields_data_index8 ON jahia_fields_data ( pageid_jahia_fields_data,ctnid_jahia_fields_data,rank_jahia_fields_data,id_jahia_fields_data );

CREATE INDEX jahia_fields_data_index9 ON jahia_fields_data ( pageid_jahia_fields_data,workflow_state,id_jahia_fields_data );

CREATE INDEX jahia_fields_data_index10 ON jahia_fields_data ( pageid_jahia_fields_data,fielddefid_jahia_fields_data );

CREATE INDEX jahia_fields_def_index ON jahia_fields_def ( id_jahia_fields_def );

CREATE index jahia_fields_def_index2 ON jahia_fields_def ( jahiaid_jahia_fields_def );

CREATE INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop ( flddefid_jahia_fields_def_prop );

CREATE INDEX jahia_fields_def_prop_index2 ON jahia_fields_def_prop ( type_jahia_fields_def_prop,default_jahia_fields_def_prop );

CREATE INDEX jahia_fields_def_extprop_index ON jahia_fields_def_extprop ( id_jahia_fields_def );

CREATE INDEX jahia_link_index ON jahia_link ( right_oid );

CREATE INDEX jahia_pages_data_index ON jahia_pages_data ( id_jahia_pages_data,workflow_state, version_id);

CREATE INDEX jahia_pages_data_index2 ON jahia_pages_data ( workflow_state,parentid_jahia_pages_data,version_id,id_jahia_pages_data );

CREATE INDEX jahia_pages_data_index3 ON jahia_pages_data ( rights_jahia_pages_data );

CREATE INDEX jahia_pages_data_index4 ON jahia_pages_data ( parentid_jahia_pages_data ) ;

CREATE INDEX jahia_pages_data_index5 ON jahia_pages_data ( workflow_state,parentid_jahia_pages_data,id_jahia_pages_data,version_id );

CREATE INDEX jahia_pages_data_index6 ON jahia_pages_data ( parentid_jahia_pages_data,workflow_state,id_jahia_pages_data,version_id );

CREATE INDEX jahia_pages_data_index7 ON jahia_pages_data ( parentid_jahia_pages_data,id_jahia_pages_data,version_id );

CREATE INDEX jahia_pages_def_prop_index ON jahia_pages_def_prop ( id_jahia_pages_def_prop );

CREATE INDEX jahia_pages_def_prop_index2 ON jahia_pages_def_prop ( name_pages_def_prop,value_pages_def_prop );

CREATE INDEX jahia_user_prop_index ON jahia_user_prop ( id_jahia_users,provider_jahia_user_prop,userkey_jahia_user_prop );

CREATE INDEX jahia_users_index ON jahia_users ( name_jahia_users,siteid_jahia_users );

CREATE INDEX jahia_users_index2 ON jahia_users ( siteid_jahia_users );

CREATE INDEX jahia_users_index3 ON jahia_users ( key_jahia_users );

 

De : ghislain.cussonneau [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 9 septembre 2005 10:03
À : dev_list
Objet : Re:Index

 

Did you read the "Fines-tuning tips" on Jahia.Org site (http://www.jahia.org/jahia/Jahia/devzone/doc) ?


There's a first list of index that you can complete after some analyze of your system. The best way is to log the SQL requests received by your database and analyze the log after some days to know which request are the more used and determine new indexes.

 

Which database did you use ? In case of PostgreSQL, try the vaccumdb command (in PostgreSQL bin directory) to update the statistics and optimize the index. On other DB, find the way to update the statistics and optimize the index.

 

 

 

I have a performance problem on a jahia web site.

I have more than 2500 pages on this site and then this very slow.

 

I am trying to create index on the database.

 

Is anyone has a script to do that ?

I use jahia 4.1.

 

I have try to use the p6spy and sql profiling without success.

 

I do exactly what is write on the guide administration guide, but GUI didn’t receive a connection.

 

Is anyone can help me?

Is any one has a idea about this performance problem?

 

Thanks for your help.

 

Nicolas

 

 

 

Ghislain CUSSONNEAU

DIRR/DPIL/CIS

CAP 44, Rue Marcel Sembat

44000 Nantes

02 51 84 48 80

CRIL Technology

Technoparc de l'Aubinière

44000 Nantes

02 51 89 64 50

 

 

Accédez au courrier électronique de La Poste : www.laposte.net ;

3615 LAPOSTENET (0,34 /mn) ; tél : 08 92 68 13 50 (0,34/mn)

Reply via email to