Enormous table alf_prop_link, what is this?

[robertocappa]

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 table was not changed.

Anyone can help me about the meaning of this table?

I am astonished that a popular document system like Alfresco has no documentation about DB Tables a and Columns.

Thanks.

[7joeblack8]

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

[robertocappa]

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

[7joeblack8]

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.

[robertocappa]

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.

[mariolebrun]

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 !