topic Relazioni tra documenti in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/relazioni-tra-documenti/m-p/48738#M27953 <HTML><HEAD></HEAD><BODY><SPAN>Ciao,</SPAN><BR /><SPAN>devo associare più allegati ad un documento principale. L'associazione funziona ma è molto lenta e di conseguenza, più allegati ci sono, più sono grandi e più è lenta questa funzionalità.</SPAN><BR /><SPAN>Come posso risolvere il problema?</SPAN><BR /><SPAN>In seguito il codice</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />public static void updateDocumentRelated(Session session, String root, String sourceObjectId, String targetObjectId,long idRepositoryPrincipale,long idRepositoryAllegato) throws Exception {<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Document doc = getDocumentInFolderByidRepository(session, idRepositoryPrincipale, root);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (doc==null){<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;throw new Exception("Il documento con idRepository " + idRepositoryPrincipale + " non è stato trovato su Alfresco");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //Estraggo tutti i figli del documento principale<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ObjectType typeDefinition = session.getTypeDefinition("R:documento:related");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OperationContext operationContext = session.createOperationContext();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RelationshipDirection direction = RelationshipDirection.SOURCE;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ItemIterable&lt;Relationship&gt; relationships = session.getRelationships(doc,true, direction, typeDefinition, operationContext);<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Creo la relazione bilaterale <BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Map relProps = new HashMap();<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Dall'allegato verso il documento principale<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps = new HashMap();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps.put("cmis:sourceId", targetObjectId);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps.put("cmis:targetId", sourceObjectId);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps.put("cmis:objectTypeId", "R:docarea:related");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;session.createRelationship(relProps, null, null, null);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Collego anche il documento allegato ad ogni fratello <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//che non sia stato già collegato<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (relationships==null ) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //Dal documento principale verso l'allegato<BR />&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps = new HashMap();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps.put("cmis:sourceId", sourceObjectId);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps.put("cmis:targetId", targetObjectId);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps.put("cmis:objectTypeId", "R:docarea:related");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;session.createRelationship(relProps, null, null, null);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;return;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Document docAllegato = getDocumentInFolderByidRepository(session, idRepositoryAllegato, root);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ItemIterable&lt;Relationship&gt; brotherships = session.getRelationships(docAllegato,true, direction, typeDefinition, operationContext);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for (Relationship relationship : relationships) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Document relatedDocument = (Document) relationship.getTarget();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //Dall'allegato verso i fratelli se non sono già presenti<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; boolean esiste = false;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (brotherships!=null ){<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; for (Relationship brothership : brotherships) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;Document brotherDocument = (Document) brothership.getTarget();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;if (brotherDocument.getId().equals(relatedDocument.getId())) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;esiste = true;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;break;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (!esiste){<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; relProps = new HashMap();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps.put("cmis:sourceId", targetObjectId);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps.put("cmis:targetId", relatedDocument.getId());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps.put("cmis:objectTypeId", "R:docarea:related");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;session.createRelationship(relProps, null, null, null);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Riporto anche il documento sui fratelli<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; relProps = new HashMap();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps.put("cmis:sourceId", relatedDocument.getId());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps.put("cmis:targetId", targetObjectId);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps.put("cmis:objectTypeId", "R:docarea:related");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;session.createRelationship(relProps, null, null, null);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //Dal documento principale verso l'allegato<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps = new HashMap();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps.put("cmis:sourceId", sourceObjectId);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps.put("cmis:targetId", targetObjectId);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;relProps.put("cmis:objectTypeId", "R:docarea:related");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;session.createRelationship(relProps, null, null, null);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR /><BR /> &nbsp;&nbsp;&nbsp;}<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Mon, 22 Sep 2014 14:57:48 GMT fedemori 2014-09-22T14:57:48Z Relazioni tra documenti https://connect.hyland.com/t5/alfresco-archive/relazioni-tra-documenti/m-p/48738#M27953 Ciao,devo associare più allegati ad un documento principale. L'associazione funziona ma è molto lenta e di conseguenza, più allegati ci sono, più sono grandi e più è lenta questa funzionalità.Come posso risolvere il problema?In seguito il codicepublic static void updateDocumentRelated(Session sessio Mon, 22 Sep 2014 14:57:48 GMT https://connect.hyland.com/t5/alfresco-archive/relazioni-tra-documenti/m-p/48738#M27953 fedemori 2014-09-22T14:57:48Z Re: Relazioni tra documenti https://connect.hyland.com/t5/alfresco-archive/relazioni-tra-documenti/m-p/48739#M27954 <HTML><HEAD></HEAD><BODY><SPAN>Il motore di associazione di Alfresco è basato essenzialmente sull'utilizzo del database, in pratica le associazioni non vengono indicizzate. Questo infatti può impattare sulle performance.</SPAN><BR /><BR /><SPAN>Le soluzioni possibili sono due:</SPAN><BR /><SPAN>1. Tuning del database e del connection pool</SPAN><BR /><SPAN>2. Tuning della cache</SPAN><BR /><SPAN>3. Modellazione dell'associazione tramite content model</SPAN><BR /><BR /><BR /><SPAN>La soluzione 2 è attuabile solo su sistemi a 64bit e con molta memoria disponibile, potresti fare qualche iterazione di tuning provando ad incrementare i valori della cache del 50% di volta in volta.</SPAN><BR /><BR /><SPAN>La soluzione 3, ovvero la modellazione dell'associazione è la soluzione più radicale e che ti permetterebbe di indicizzare tutte le associazioni. In questo caso le performance ovviamente saranno sempre eccellenti.</SPAN><BR /><BR /><SPAN>La soluzione 1 non è sempre praticabile poiché dipende fortemente dall'ambiente.</SPAN></BODY></HTML> Tue, 30 Sep 2014 10:36:44 GMT https://connect.hyland.com/t5/alfresco-archive/relazioni-tra-documenti/m-p/48739#M27954 openpj 2014-09-30T10:36:44Z Re: Relazioni tra documenti https://connect.hyland.com/t5/alfresco-archive/relazioni-tra-documenti/m-p/48740#M27955 <HTML><HEAD></HEAD><BODY><SPAN>ok grazie, come si fa a modellare l'associazione? Ti posso girare via mail il mio customModel.xml Grazie</SPAN></BODY></HTML> Thu, 16 Oct 2014 07:15:53 GMT https://connect.hyland.com/t5/alfresco-archive/relazioni-tra-documenti/m-p/48740#M27955 fedemori 2014-10-16T07:15:53Z