topic Alfresco webapp very slow in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-webapp-very-slow/m-p/123795#M87143 <HTML><HEAD></HEAD><BODY><SPAN>I use Alfresco 1.4.0 with a Oracle database</SPAN><BR /><SPAN>Alfesco uses very often the following query:</SPAN><BR /><BR /><SPAN>SELECT childassoc0_.type_qname col_0_0_, childassoc0_.qname col_1_0_, </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; childassoc0_.is_primary col_2_0_, childassoc0_.assoc_index col_3_0_, </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; nodeimpl2_.id col_4_0_, nodeimpl2_.protocol col_5_0_, </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; nodeimpl2_.identifier col_6_0_, nodeimpl2_.uuid col_7_0_</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; FROM alf_child_assoc childassoc0_, alf_node nodeimpl1_, alf_node nodeimpl2_</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; WHERE childassoc0_.child_node_id = nodeimpl2_.id</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND childassoc0_.parent_node_id = nodeimpl1_.id</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND childassoc0_.parent_node_id = :1</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; ORDER BY childassoc0_.assoc_index, childassoc0_.id</SPAN><BR /><BR /><SPAN>But the run of this query takes 1min20.</SPAN><BR /><SPAN>How could I optimize the execution of this query?</SPAN><BR /><BR /><SPAN>Thanks a lot for your answer.</SPAN><BR /><SPAN>Luc</SPAN></BODY></HTML> Thu, 10 Jan 2008 09:49:17 GMT lmoulin 2008-01-10T09:49:17Z Alfresco webapp very slow https://connect.hyland.com/t5/alfresco-archive/alfresco-webapp-very-slow/m-p/123795#M87143 I use Alfresco 1.4.0 with a Oracle databaseAlfesco uses very often the following query<IMG id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />ELECT childassoc0_.type_qname col_0_0_, childassoc0_.qname col_1_0_, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; childassoc0_.is_primary col_2_0_, childassoc0_.assoc_index col_3_0_, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; nodeimpl2_.id col_4_0_, nodeimpl2_.protocol col_5_0_, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Thu, 10 Jan 2008 09:49:17 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-webapp-very-slow/m-p/123795#M87143 lmoulin 2008-01-10T09:49:17Z Re: Alfresco webapp very slow https://connect.hyland.com/t5/alfresco-archive/alfresco-webapp-very-slow/m-p/123796#M87144 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>This release and oracle did not play well (hibernate not creatng some indexes you would expect). I suggest you upgrade.</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Tue, 29 Jan 2008 12:04:12 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-webapp-very-slow/m-p/123796#M87144 andy 2008-01-29T12:04:12Z