Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Store survey data in several tables

Store survey data in several tables 4 years 2 months ago #81049

  • krefik
  • krefik's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 3
  • Thank you received: 1
  • Karma: 1

Hello, everyone.

I just bumped into quite big obstacle - almost finishing survey, found that I am unable to activate it, due to column number too high either for postgres or mysql. I know that there's possibility to join few surveys end urls, but I have quite complicated logical structure, and number of variables needed to pass would be rather huge.

My idea is to add new survey attribute that allow creation of huge questionnaires by storing survey data in few tables (ie. every question group in different table) transparently for user.

How do you think? It wouldn't be hard to implement, and will remove 1000/1600/4096 variable limit (which isn't much for complicated survey).
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.205 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form