topic How to calculate total docs in alfresco? in Alfresco Forum

How to calculate total docs in alfresco?

yogeshpj — Mon, 02 Jul 2018 18:59:27 GMT

I am planning to do re-indexing of couple of tera bytes data in alfresco.For that, I am doing re-indexing with smaller set of data and make benchmark on that and tune as deeply it can be. After measuring performance for smaller set of data, calculate re-indexing time for actual data.To have benchmar

Re: How to calculate total docs in alfresco?

abhysunny — Tue, 03 Jul 2018 04:22:32 GMT

I also have this question: I have been relying on CMIS query to find count of documents IN TREE of the root folder. For me, the requirement was to get an approximate count for metric. What is the best approach ?

Re: How to calculate total docs in alfresco?

charlesdaumont — Tue, 31 Jul 2018 14:03:00 GMT

Hi,

The best way to do it is to find it through your database, here is a request I used to count documents and folders, adapt it to your context (I hope it works ) :

select a.local_name, b.protocol, count(*)

from alf_qname as a, alf_store as b, alf_node as c

where a.local_name in ('content', 'folder')

and b.protocol in ('workspace', 'archive') and b.identifier = 'SpacesStore'

and c.store_id = b.id and c.type_qname_id = a.id

group by a.local_name, b.protocol;

The number of document is not enough to calculate your indexing time. You should also consider :

number of versions
number of indexed metadata
text content size if you index your contents

I hope these answers will help you.

Charles Daumont

Sopra Steria