We are creating custom fields for users like annual income, gender, city, country, etc. There are about 10 odd new fields. We will be importing approx. 30,000 records for each user in a month through a CSV import function. There will be new as well as update to old records. The process will continue for a year. In this scenario, please suggest which option to choose from
Scenario 1: Create a new WordPress table with these new fields
Scenario 2: Use wp_usermeta to add custom fields
Apart from CSV import, we will be regularly extracting reports of users. This will keep the wp_usermeta table busy.
Please suggest which scenario we should go far and why? My recommendation is to go for Scenario 1 as here we can use WordPress functions quite efficiently though the database load will be high.