I'm facing an architectural design where a company could have more than 10k locations, and I would like to save the location data, according to this link it's a good practice to use a hierarchical approach, where I have a parent Account (main company), and the child accounts as the different locations, for example: The company Macdonald has several locations in the US, and I would like to represent in my Salesforce org the locations and the main company (parent). If I do the approach of using a parent account and child accounts (locations), then I could probably run into a data skew problem.
What would be a good approach in this kind of situation?
Any help would be appreciated, thanks!