Welcome, Guest
Username: Password: Remember me

TOPIC: Survey extremely slow

Survey extremely slow 1 year 2 months ago #97322

  • henkvanramshorst
  • henkvanramshorst's Avatar
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?
The administrator has disabled public write access.

Survey extremely slow 1 year 2 months ago #97329

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6276
  • Thank you received: 801
  • Karma: 241
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
The administrator has disabled public write access.

Survey extremely slow 1 year 2 months ago #97333

  • henkvanramshorst
  • henkvanramshorst's Avatar
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
The administrator has disabled public write access.

Survey extremely slow 1 year 2 months ago #97523

  • jelo
  • jelo's Avatar
  • OFFLINE
  • Platinum Lime
  • Posts: 467
  • Thank you received: 52
  • Karma: 16
Which version of Limesurvey is used?
Which database?

Which hoster? Which package?

Perhaps you can attach the surveyfile here or send via private mail?
The administrator has disabled public write access.

Survey extremely slow 1 year 2 months ago #97540

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6276
  • Thank you received: 801
  • Karma: 241
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
The administrator has disabled public write access.

Survey extremely slow 1 year 2 months ago #97554

  • jelo
  • jelo's Avatar
  • OFFLINE
  • Platinum Lime
  • Posts: 467
  • Thank you received: 52
  • Karma: 16
Why is this thread posted under "Development"?

[EDIT="DenisChenu"]Moderate / move to Design issues[/EDIT]
Last Edit: 1 year 2 months ago by DenisChenu.
The administrator has disabled public write access.
The following user(s) said Thank You: DenisChenu
Moderators: ITEd
Time to create page: 0.127 seconds
Donation Image