Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: Survey extremely slow

Survey extremely slow 1 Jahr 4 Monate her #97322

  • henkvanramshorst
  • henkvanramshorsts 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?
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Survey extremely slow 1 Jahr 4 Monate her #97329

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 6451
  • Dank erhalten: 844
  • Karma: 249
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
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Survey extremely slow 1 Jahr 4 Monate her #97333

  • henkvanramshorst
  • henkvanramshorsts 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
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Survey extremely slow 1 Jahr 3 Monate her #97523

  • jelo
  • jelos Avatar
  • OFFLINE
  • Platinum Lime
  • Beiträge: 470
  • Dank erhalten: 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?
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Survey extremely slow 1 Jahr 3 Monate her #97540

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 6451
  • Dank erhalten: 844
  • Karma: 249
jelo schrieb:
Which hoster? Which package?
+1
jelo schrieb:
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
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Survey extremely slow 1 Jahr 3 Monate her #97554

  • jelo
  • jelos Avatar
  • OFFLINE
  • Platinum Lime
  • Beiträge: 470
  • Dank erhalten: 52
  • Karma: 16
Why is this thread posted under "Development"?

[EDIT="DenisChenu"]Moderate / move to Design issues[/EDIT]
Letzte Änderung: 1 Jahr 3 Monate her von DenisChenu.
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Folgende Benutzer bedankten sich: DenisChenu
Moderatoren: ITEd
Ladezeit der Seite: 0.128 Sekunden
Donation Image