Welcome, Guest
Username: Password: Remember me

TOPIC: Tokens vs separate surveys

Tokens vs separate surveys 2 years 10 months ago #67907

  • lovepade
  • lovepade's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 93
  • Karma: 0
Hi forum,

I hope someone here can help with a quck DB question:

I am conducting 10 almost identical surveys on 10 different schools. Would it be more efficient to conduct one survey, with different tokens attributes (for each school there needs to be 6 different custom token attributes), or would it be most efficient to create 10 different surveys?

I don't know much about databases, but I feel that option one would be less redundant then option two. Is that correct?

Thanks in advance.
Andreas
The administrator has disabled public write access.

Re: Tokens vs separate surveys 2 years 10 months ago #67910

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5325
  • Thank you received: 296
  • Karma: 249
From a storage point of you it doesn't really matter much, there won't be much overhead.
I would prefer to create one base survey and then create six copies of it. That also makes data analysis easier because you can have one export file for each school.
If you want to compare results, having everything in one survey would be more comfortable though.

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.

Re: Tokens vs separate surveys 2 years 10 months ago #67921

  • lovepade
  • lovepade's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 93
  • Karma: 0
Thanks. The merging (or splitting) of the data is not important for me (easy to do). I am more concerned of database overhead. Maybe mySQL prefers to write 10 times to the same table, than 10 times to 10 different tables?
The administrator has disabled public write access.

Re: Tokens vs separate surveys 2 years 10 months ago #67926

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5325
  • Thank you received: 296
  • Karma: 249
lovepade wrote:
I am more concerned of database overhead. Maybe mySQL prefers to write 10 times to the same table, than 10 times to 10 different tables?
That really doesn't matter much.

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.
The following user(s) said Thank You: lovepade
Moderators: ITEd
Time to create page: 0.110 seconds
Donation Image