I need to store share prices for a lot of shares (over 16000) in a database daily and I wonder what would be the best way to do this. How efficient would it be to create a table with these 16000+ columns and then add the prices for the shares with an INSERT? What if I have to add a few columns every know and then?
Does anyone have experience with this kind of tables or has a different idea on how to store the data?
Thanks in advance!