From your description I understand you were trying to link all your assets to a certain resource by using out-of-box resource association "Associated Assets". However, considering the number of your assets it may not be a best practice to do it your way. Associating such a sizable group of Assets via Resource Association will inevitably cause big performance issue.
Besides performance consideration, what if there is a new asset coming in and you will have to remember to add this new asset to this resource association as well?
Consider what your requirements are:
- Do you really need to display these associated assets directly?
- Do you need to add/remove these associated assets when the number of assets changed?
If answers to the first question is NO and the second is YES, then I'd recommend to implement this in a user defined data class:
- Create a new data class with a single column, whose content is a filter as Item Foreign Key of this data class.
- And add this data class to your Asset resource type.
- Create a filter which includes all the assets satisfying your requirements.
- Go to the Edit page for your selected asset, locate the newly added data class and select the filter you just created as its data.