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

TOPIC: Maximum number of attributes?

Maximum number of attributes? 2 years 4 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? 10 months 2 days 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? 10 months 2 days ago #130868

  • holch
  • holch's Avatar
  • Online
  • LimeSurvey Team
  • Posts: 5429
  • Thank you received: 809
  • Karma: 240
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 | [url=https://manual.limesurvey.org/Workarounds[/url]

If you found this answer helpful and it saved you some time please consider a [url=https://donate.limesurvey.org[/url] to the...
The administrator has disabled public write access.

Maximum number of attributes? 10 months 8 hours ago #130997

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9580
  • Thank you received: 1374
  • Karma: 390
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 development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (use private message).
The administrator has disabled public write access.

Maximum number of attributes? 9 months 4 weeks ago #131041

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 6029
  • Thank you received: 373
  • 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)survey-consulting.com'"
The administrator has disabled public write access.

Maximum number of attributes? 6 months 3 weeks ago #135846

  • duvemyster
  • duvemyster's Avatar
  • Offline
  • Junior 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: 6 months 3 weeks ago by duvemyster. Reason: typo
The administrator has disabled public write access.

Maximum number of attributes? 6 months 3 weeks ago #135870

  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 1033
  • 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.
Time to create page: 0.280 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form