We have a tool shop and anticipate having around 40K simple products. With that we anticipate having around 2500 attribute sets, and as many as 10,000 attributes. I'm concerned about system performance, searching and page load speed. Would it be better to try to reuse as many attributes as possible?
For example Size, Color, Type, Material are attributes used frequently. These are filterable attributes too, so we will have to set them up as dropdown attributes.
Question: Is it better to try to reuse these attributes among many different attribute sets? Or would that be harder for the store owner when he's maintaining all these products.
Please advise and let me know what the best practices are.