Recently I got required of creating Common data item which will be useful in different component by mapping as data source. This Common data item template is having appx. 40 fields ( single line text, drop down list , custom controls etc ). Based on this new template around 500 ( as per business : 500 different offices ) sitecore items will be created.
Based on above data below components will be implemented : Component x : will use 5 fields of the created common data items Component y : will use 10 fields of the created common data items. Similarly, in future multiple Components will be created when required.
Search : searching this 500 common data items and display results ( Using Coveo search) will result in any performance issue ?
Is it a good practice to create 40 fields in one template ? will it create any performance issues in future?