Hey everyone, i’m about to start working on a project & wanted to check my database structure plan here before i start. Thanks for reading!
The project is a sports stats & info browser. The user will be able to do a search for a player & then their relevant stats & info will be shown.
My thinking is that i need to have two data types:
Player Names : all player names, to be loaded on page load for easy searching
Stats & info: searched for after Player Name is selected
Is that the best way? Should i nest one of these inside the other & will that slow things down? Ultimately this will be thousands of players with many years of stats. I’d like to design it correctly instead of trying to fix it down the road haha.