Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Sessions in LS: Session files vs. Database Sessions - advantages/disadvantages?

  • holch
  • holch's Avatar Topic Author
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 months 1 week ago #245136 by holch
Hi everyone!

Due to a post on the forum I was wondering if we could collect some pros and cons of both ways to lead with sessions in Limesurvey: file based and table based.

So I would like to collect the advantages and disadvantages of both approaches and what to consider for both, in your experience in general and with Limesurvey in specific.

Here some questions that users might have:
  • When to choose one over the other? When would you use table over files and viseversa?
  • In your experience, what is faster? Under which circumstances?
  • What requires more storage space / memory?
  • Is there any difference in your evaluation / recommendation when you use SSD instead of HDD?
  • How are table based sessions impacted if the database is on a different server?
  • What is better for big, long surveys? What is better for short surveys?
  • etc (please feel free to add aspects that I didn't consider but you think are important)
I think it would be great if everyone could chime in and add their thoughts. I will try to make a manual page out of it, if we get some good content.

Thank you for your help already in advance!

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose