I have a large number of fields to add to the projects module layout form and find that I hit what seems to be a limit.
All fields add with no problem
When using the layout system it becomes a bit sluggish and unresponsive.
I get to a limit of adding fields and I am unable to continue to add any more.
I have removed a number of check box fields and replaced them with multi select one to reduce the number of fields I need however I still seem to hit the limit.
I have tried:-
Other browsers
Creating the panels and filters in other areas
Changing themes
I was wondering if the field this information is stored in, in the mysql database might have reached a limit.
Any ideas? I’m not sure if its a bug or there is something I am missing
I’m not sure there is a limit but I have redesigned a large amount of the form with the same result.
It isn’t specific to any one field, after the redesign the form reached a “limit” and I couldn’t added any field.
I looked in the metadata file and seems like it is all in order i could be wrong the size is around 62kb.
I will look into creating an custom view if the new shorter version I am working on does’t work.
I have looked in the logs but there is nothing but cron errors in there.
Apologies for going off on a tangent, but if Studio is having trouble handling so much stuff, I really pity your users… : - )
Can’t you redesign that database? Find some pattern between the fields and group them as separate items in a related table?
I don’t know your dataset, but peeking at the screenshot you posted earlier, I would say you could try having a separate entity called “room”, and so each room would be a row in a related table, with its own notes fields, etc. Things would look much tidier.
Thanks for your comments. I have done a small amount of data normalising already. The info is based on new house builds and as such has quite a lot of data collection to do with as it cover the whole build. Although I am able to create data tables and create this in the backend fairly well my limitation is time and frontend ability. My background is more dotnet so quite a leap over to php.
I think if this time I come across the same issue I will look at creating by own module/view.
In the php.ini file I had to change the default limit on max_input_vars from 1000 to 10000. Not sure what the implication of this might be but I will change this back at a later date to see what effect this has.