This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi I've got this One to Many Association (Advert -> Price Type) where if I tried to change the price type of an existing ad it will take about 20 to 30 seconds to update because price type will load the advert collection (which could run into hundreds of thousands of ads) associated with the price type. Is there a way where I can omit loading the advert collection or have I incorrectly set the association wrong? Thanks Allen |
|
|
If PriceType is reference data, you can do this by deleting the Adverts collection name off the association. This will make it a one-way association so that Advert will still have a PriceType reference but PriceType will not have an Adverts collection. Note that we require PriceType to be cached in this case which is why it is only suitable for reference data. You can set caching for PriceType using the Cached and Cache Expiry options in the Properties window. If PriceType isn't reference data and can't be cached, let us know; there is still a way of doing this but it's a bit more fiddly. |
|
|
Yes I made it one way association and that works fine now thanks for the suggestion! |
|