Workarounds for extra large survey

3 years 5 months ago #128656 by wingman123
Hi all,

If I'm creating a survey with 1000+ questions, when activating, I run into the issue of SQL : Too many columns error since the questions are stored as fieldnames in the response table and MySQL has limits on column size/row bytes. Aside from splitting up this extra large survey into smaller ones, what are possible solutions to having an extra large survey?
So far I've considered splitting the response table into smaller tables but that would require me to rewire the SurveyDynamic model somehow for handling survey responses. Not exactly the cleanest solution (not even sure if its a solution :) ). Does anyone have any other ideas?


Please Log in or Create an account to join the conversation.

LimeSurvey Partners

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!