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

TOPIC: Maximum number of attributes?

Maximum number of attributes? 2 years 3 days 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? 5 months 3 weeks 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.
lemonlimebitters
The administrator has disabled public write access.

Maximum number of attributes? 5 months 3 weeks ago #130868

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5063
  • Thank you received: 749
  • Karma: 227
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? 5 months 2 weeks ago #130997

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

If i don't make error.
Assistance on LimeSurvey forum and LimeSurvey core developpement are on my free time (Say thanks ?).
A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous
The administrator has disabled public write access.

Maximum number of attributes? 5 months 2 weeks ago #131041

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5974
  • Thank you received: 366
  • Karma: 260
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.

Maximum number of attributes? 2 months 2 weeks ago #135846

  • duvemyster
  • duvemyster's Avatar
  • Offline
  • Premium Lime
  • Posts: 24
  • Thank you received: 5
  • Karma: 2
I noticed a decrease in the maximum number of attributes between versions 2.06 vs. 2.50+ with the same database. Is this due to the change from utf8_unicode_ci to utf8mb4_unicode_ci?

In my case:
  • Version 2.06lts Build 160417 has a maximum of 82 attributes
  • Version 2.50+ Build 160506 only has a maximum of 62 attributes
Last Edit: 2 months 2 weeks ago by duvemyster. Reason: typo
The administrator has disabled public write access.

Maximum number of attributes? 2 months 2 weeks ago #135870

  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 999
  • Thank you received: 135
  • Karma: 97
Yes, the new character set uses more space so high-bit UTF-8 characters can be stored.
Best regards

Carsten Schmitz
LimeSurvey project leader
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.248 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form