- Posts: 25
- Thank you received: 0
Would be a problem to create 180 custom fields
10 years 5 months ago #243271
by ingjjaa
Would be a problem to create 180 custom fields was created by ingjjaa
-- HikaShop version -- : 3.5.6
-- Joomla version -- : 3.5.2
-- PHP version -- : 5.4
-- Browser(s) name and version -- : chrome
-- Error-message(debug-mod must be tuned on) -- : Maximun number of custom fields
Hi i know that that would sound crazy i thought that when my customer required me that but he want to have 180 fields, those field is going to be just text but i have never see any mysql table with around 200 columns, Do you think that could be possible or it could create any problem???
-- Joomla version -- : 3.5.2
-- PHP version -- : 5.4
-- Browser(s) name and version -- : chrome
-- Error-message(debug-mod must be tuned on) -- : Maximun number of custom fields
Hi i know that that would sound crazy i thought that when my customer required me that but he want to have 180 fields, those field is going to be just text but i have never see any mysql table with around 200 columns, Do you think that could be possible or it could create any problem???
Please Log in or Create an account to join the conversation.
10 years 4 months ago #243291
by nicolas
Replied by nicolas on topic Would be a problem to create 180 custom fields
Hi,
It's not a problem.
MySQL can handle up to 4000 columns in a table.
Of course, the more columns in the table, the slower the queries are so it's best to try to not have too many of them. But 200 should still be fine unless you have hundred of thousands of entries in the table.
It's not a problem.
MySQL can handle up to 4000 columns in a table.
Of course, the more columns in the table, the slower the queries are so it's best to try to not have too many of them. But 200 should still be fine unless you have hundred of thousands of entries in the table.
Please Log in or Create an account to join the conversation.
10 years 4 months ago #243374
by ingjjaa
Replied by ingjjaa on topic Would be a problem to create 180 custom fields
Thanks for the answer and i would like to ask you the 180 fields are going to field text fields is there any way that i could create them by mysql o duplicate one 100 times
Please Log in or Create an account to join the conversation.
10 years 4 months ago #243382
by nicolas
Replied by nicolas on topic Would be a problem to create 180 custom fields
Hi,
You would have to add the columns in the destination table by hand via phpmyadmin and then run an export/import on the hikashop_field table to create the corresponding entries there.
So it's possible if you know your way around in phpmyadmin.
You would have to add the columns in the destination table by hand via phpmyadmin and then run an export/import on the hikashop_field table to create the corresponding entries there.
So it's possible if you know your way around in phpmyadmin.
Please Log in or Create an account to join the conversation.
Time to create page: 0.056 seconds