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?
-
3Why would you want to do this?– George.PalaciosJan 10, 2019 at 12:20
-
2Nobody is going to want to fill out a form with more than 3000 fields. It may be time to step back and see if there is another way to accomplish what you are trying to do without having a form with that many fields.– DaveJan 10, 2019 at 13:02
-
Other are optional– Achoda jamesJan 10, 2019 at 13:26
-
1You have to look at the EAV model.– KondybasJan 10, 2019 at 14:33
-
1Study Limits on Table Column Count and Row Size.– AkinaJan 11, 2019 at 4:57
Add a comment
|
1 Answer
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.
answered Jan 12, 2019 at 1:59
