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
1 year 6 months 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!

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

More
3 months 2 weeks ago #267491 by r0bis
Sorry that there have not been any replies. I will try to say something once I get my head around it. Unfortunately the only bit in LS manual is very scant and the only other forum post that comes up for ls db sessions search is this forums.limesurvey.org/forum/can-i-do-thi...sed-sessions-to-work

So there is no clear evidence of db sessions even working. I would say that this bit in manual needs some serious work. Happy to contribute

r0berts

Please Log in to join the conversation.

  • holch
  • holch's Avatar Topic Author
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 months 2 weeks ago - 3 months 2 weeks ago #267519 by holch
Hahahaha, I didn't even remember that I made this post.

It was a try to get some better information out about sessions in Limesurvey, but this post didn't get any feedback, so this probably didn't go forward.

You are citing a 5 year old thread there, for a version that was at the very beginning of this branch and which is now EOL for while and not supported.

I assume that dabase sessions are working, otherwise we would see more complaints in the forum or bug reports coming up. If you tried database sessions and it isn't working, please file a bug report!

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
Last edit: 3 months 2 weeks ago by holch.

Please Log in to join the conversation.

Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose