Survey extremely slow

  • henkvanramshorst
  • henkvanramshorst's Avatar Topic Author
  • Visitor
  • Visitor
4 years 4 months ago #97322 by henkvanramshorst
henkvanramshorst created the topic: Survey extremely slow
Hi,

I have just developed my first survey. Everything seemed fine the whole time, but when I launched my survey everything went wrong. The survey became so slow (about 1 minute to load a new page) that everyone complains that it doesn't work.

So what went wrong?

It seems that the huge number of colums (1.444) in my results table (generated after I activated the survey) is causing the problem. I contacted my hosting provider and they told me that shared webhosting is not suitable for such applications. Now I don't know what to do, should I find another webhost which is fast enough or should I redesign the whole survey?

I have a few questions using a long list of checkboxes, and these questions are repeated 9 times. That's why I have so many columns (but I don't see any other way to design my survey, since I need these checkboxes).

In which direction should I look for a solution?

Please Log in to join the conversation.

More
4 years 4 months ago #97329 by DenisChenu
DenisChenu replied the topic: Survey extremely slow
Your survey is all in one page ?

If yes : best is to seperate your survey Group by group.

And we don't know your hoster, then we can not answer.

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

  • henkvanramshorst
  • henkvanramshorst's Avatar Topic Author
  • Visitor
  • Visitor
4 years 4 months ago #97333 by henkvanramshorst
henkvanramshorst replied the topic: Survey extremely slow
It is on several pages, about 15 I guess. Which pages are shown depends on the answers provided by the users. But it results in one single (and very large) results table.

I think my hoster is OK. But may there be a solution to use a very fast webhosting solution (for just a few months) to overcome the problem?

-- Henk

Please Log in to join the conversation.

More
4 years 4 months ago #97523 by jelo
jelo replied the topic: Survey extremely slow
Which version of Limesurvey is used?
Which database?

Which hoster? Which package?

Perhaps you can attach the surveyfile here or send via private mail?

Please Log in to join the conversation.

More
4 years 4 months ago #97540 by DenisChenu
DenisChenu replied the topic: Survey extremely slow

jelo wrote: Which hoster? Which package?

+1

jelo wrote: Perhaps you can attach the surveyfile here or send via private mail?

Or use our bug report system and a "private" issue (only LS core dev have access to survey and mantis).

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
4 years 4 months ago - 4 years 4 months ago #97554 by jelo
jelo replied the topic: Survey extremely slow
Why is this thread posted under "Development"?

[EDIT="DenisChenu"]Moderate / move to Design issues[/EDIT]
Last Edit: 4 years 4 months ago by DenisChenu.
The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!