topic Re: Enormous table alf_prop_link, what is this? in Alfresco Archive

Enormous table alf_prop_link, what is this?

robertocappa — Wed, 24 Apr 2013 14:08:12 GMT

On my Alfresco 4.0d database schema, the alf_prop_link table has reached a very very large size, but there are no so many documents in the system.I suspected this was related to old audit data, so I've used the Audit clean API. The audit_entry was empty after the cleaning procedure, but the big tabl

Re: Enormous table alf_prop_link, what is this?

7joeblack8 — Mon, 29 Apr 2013 07:51:25 GMT

Have you tried to delete permanently images through the Alfresco Explorer?

Re: Enormous table alf_prop_link, what is this?

robertocappa — Mon, 29 Apr 2013 09:14:52 GMT

Sorry, I'm not familiar with this concept. What do you mean exactly with "images"?

Re: Enormous table alf_prop_link, what is this?

7joeblack8 — Mon, 29 Apr 2013 12:13:31 GMT

i mean, u could try to delete permanently the document and restart alfresco.
Maybe after all this procedure it will rebuild indexes and delete old properties data.

Re: Enormous table alf_prop_link, what is this?

robertocappa — Mon, 29 Apr 2013 13:48:42 GMT

No, I've already tried to force clean, and rebuild indexes, but there is not changes in this table. By the way, the row count is exactly the same since months, also if documents where added/removed.

Re: Enormous table alf_prop_link, what is this?

mariolebrun — Thu, 20 Feb 2014 20:38:03 GMT

That table is linked to Alfresco audit services. We are using alfresco 3.4d (migrating slowly to 4.2e) and that table will stop growing if you modify your alfresco-global.properties file. You just have to modify

# Audit service
audit.enabled=true
audit.dod5015.enabled=true

to
# Audit service
audit.enabled=false
audit.dod5015.enabled=false

of course you will loses auditing capabilities but for us it wasn't an issue !

Hope it will help !