What are the best practices for handling RDBMS table relationships. We usually c

sariqs over 9 years ago

What are the best practices for handling RDBMS table relationships. We usually create CDTs to map with our tables and in case there are multiple tables associated with each other we create nested CDTs.

My questions is more around mapping the inter related tables with nested CDTs using annotations with Lazy loading enabled. As Appian uses hibernate in the backend it should support lazy loading but I have seen whole object graph is fetched in process variables even if nested CDTs are configured as lazy loading enabled. In case lazy loading isn't supported in the process variables what are the best practice to model the nested CDTs in this case ?

Please let me know.

Discussion posts and replies are publicly visible

Parents

0 PhilB
A Score Level 1
over 9 years ago

As a general rule, we nest type lookups (eg product has product type nested) but outside of that, other than in some very specific use cases, we try to avoid nesting.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 PhilB
A Score Level 1
over 9 years ago

As a general rule, we nest type lookups (eg product has product type nested) but outside of that, other than in some very specific use cases, we try to avoid nesting.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data