Welcome, Guest
Username: Password: Remember me

TOPIC: Maximum number of attributes?

Maximum number of attributes? 1 year 6 months ago #111093

  • Serafim
  • Serafim's Avatar
  • Offline
  • Expert Lime
  • Posts: 115
  • Thank you received: 2
  • Karma: 2
Hello there,

What is the maximum number of attributes that we can have in a survey?

Thanks
The administrator has disabled public write access.

Maximum number of attributes? 6 days 23 hours ago #130786

I'd like to now too. So far, i haven't found any thing that states it. Would be good to know, especially if you're doing delphi surveys which require lots of data imported into a survey via attributes in the token table.
The administrator has disabled public write access.

Maximum number of attributes? 6 days 11 hours ago #130868

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 4381
  • Thank you received: 618
  • Karma: 197
I don't think that there is any real limit to it. But you need to keep in mind that your database will have a certain limit. I think the token attributes are stored in a different table as the answers, so at least you have the two limits adding up.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Maximum number of attributes? 4 days 14 hours ago #130997

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 8218
  • Thank you received: 1122
  • Karma: 333
And there are some restriction due to size of the json saved in Survey table too.

If i don't make error.
The administrator has disabled public write access.

Maximum number of attributes? 2 days 18 hours ago #131041

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5840
  • Thank you received: 347
  • Karma: 261
lemonlimebitters wrote:
I'd like to now too. So far, i haven't found any thing that states it. Would be good to know, especially if you're doing delphi surveys which require lots of data imported into a survey via attributes in the token table.
We have recently tested this on a MySQL database and Limesurvey version 2.06. We sequentially increased the number of token attributes and noticed that at ~80 additional token attributes we started having problems activating the survey.

You can test yourself by e.g. adding 50/75/100 token attributes and then test-activate the survey. If Limesurvey fails to set up the lime_tokens_123456 table due to DB limitations there will be an error message.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.145 seconds