Resolution:
Description:
==========
If a Concept has a ConceptReference property, whenever there is an operation on this property it would result in an operation on the RRF$ table of the referencing concept in backing store.

This may cause decreased performance and generate a lot of redo log in this table if when there are very many reverse references in a shared instance (referenced by many other instances).

How to disable operations on RRF$ table in backing store?

Environment:
===========
TIBCO BusinessEvents - 4.x
OS - all

Resolution:
==========
The RRF$ table is the Reverse Reference table. To disable operations on this table an extended property called Reverse Ref has been added in BE 3.0.1 h9 and can be used in 4.x too. It allows you to disable the reverse references. Add the new extended property to relevant ConceptReference properties and set it to "false". The default value is "true".

Right click on the ConceptReference property -> Select Metadata -> Add Entry "Reverse Ref", and set the value to "false".

Note that if you use this property you must explicitly remove ConceptReference properties for deleted referenced concepts in the referring concept in your code.
For example, if employee is a ConceptReference type property in a Concept acme and smith is an instance of a Concept type employee, then you would set the extended property to true for the employee ConceptReference property and you would add something like the following to rules:

   acme.employee = null;
   Instance.deleteInstance(smith);

Or, for array properties:

   Instance.PropertyArray.removeConceptReference(acme.employee, smith);
   Instance.deleteInstance(smith);

In this example, if you are deleting 'acme' you don't need to do anything.  If you are deleting 'smith' you need to follow the logic above to do the house keeping. This property is viewable in CDD file in BE 5.x and is in the latest documentation.

How to disable operations on rrf$ table in TIBCO BusinessEvents Backing store functionality.