Subject | Re: COMPUTED BY between 2 tables |
---|---|
Author | Adam |
Post date | 2006-03-19T04:45:44Z |
Hello Klett,
When we were using computed by fields involving joins, we found it
compromised speed to the point where it became unusable. Instead for
'computed fields' which do require joins, we created a normal field
and used triggers on the respective tables to keep the information
up-to-date.
Adam
When we were using computed by fields involving joins, we found it
compromised speed to the point where it became unusable. Instead for
'computed fields' which do require joins, we created a normal field
and used triggers on the respective tables to keep the information
up-to-date.
Adam