topic Re: Alfresco direct database access in Alfresco Archive

Alfresco direct database access

pkanuri — Mon, 08 Aug 2016 11:58:22 GMT

Hi ,Apologies if this has been asked before, is it okay to access Alfresco's database directly for <strong><em>read</em></strong> operations only.One of our requirements is to be able to run around 100000 queries on Alfresco . It seems that the query time would be much reduce

Re: Alfresco direct database access

afaust — Mon, 08 Aug 2016 17:40:29 GMT

You should indicate what kind of queries you need to run. Some queries might not even need database access and could be covered by pure index / SOLR queries.

But aside from that it is fine to access the DB for read-only operations outside of the Alfresco application context. Alfresco doesn't provide documentation about the schema if that is what you mean by "publish the schema", but it is publicly accessible as part of the source code and open to anyone to analyze / query.

Re: Alfresco direct database access

gawadesk — Tue, 09 Aug 2016 04:46:59 GMT

As Alex suggested many things are possible with pure index / SOLR queries and it is always advisable to use them.

If you still wish to query in database then go for stored procedure/function as Alfresco database is normalized and you will have to perform multiple join to get data which can make life even more difficult.

Let me know what kind of query you want to perform.

Re: Alfresco direct database access

pkanuri — Tue, 09 Aug 2016 06:59:11 GMT

Thank You both Axel and Krishna. The queries are needed to fetch information of metadata only. The UUID and some metadata properties(like cm:created, cm:modified and other custom metadata) are the only ones that need to be queried for.

So, going by your answers I gather that DB queries can be made in this case.

Kindly confirm.

Thanks,
Phani