I have a form of more than 3000 fields and i want to create a table without splitting it into two.
Is it okay? Or it will have problems?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
3000 optional fields today; 3001 tomorrow. You are looking at all-to-frequent
ALTER TABLE .. ADD COLUMN..
Keep the "common" columns as MySQL columns. Put the rest into a
JSON string. Be aware that it is messy and inefficient to filter or sort on data buried inside a json string.
The EAV schema pattern has, in my opinion, worse drawbacks.