We are planning on setting up classification for the material master. Reviewing discussions on the topic indicate the potential for system performance issues with search response and file sizes. Performance is dependent on several factors such as the number of material numbers, classes and characteristics, use of interval values, depth of hierarchies ect.
We have a significant number of material numbers, looking to have at least 15 classes with about 200 total characteristics. The extent of superior class linkage is undetermined at this time.
I am looking for a guideline or tool that would help us understand if our design is efficient or will lead to long term performance issues. Is there a resource or documentation that gives some examples of situatinos where classification got our of hand and why?