I have a table in my MySQL database which contains data about XRF analyses.
There are about 50 chemical elements and for each element there are two values to be stored (Area and Count). Users need to perform queries on a specific element. The idea is that when they upload a new record, they provide a csv file and the fields are automatically filled.
My question is: is it ok to have a table with more than 100 columns? Is there a smarter way to implement this?