Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi

SUJET : Survey extremely slow

Survey extremely slow il y a 9 mois 3 semaines #97322

  • henkvanramshorst
  • Portrait de henkvanramshorst
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?
L'administrateur a désactivé l'accès en écriture pour le public.

Survey extremely slow il y a 9 mois 3 semaines #97329

  • DenisChenu
  • Portrait de DenisChenu
  • Hors ligne
  • Moderator Lime
  • Messages : 5845
  • Remerciements reçus 715
  • Karma: 222
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
L'administrateur a désactivé l'accès en écriture pour le public.

Survey extremely slow il y a 9 mois 3 semaines #97333

  • henkvanramshorst
  • Portrait de henkvanramshorst
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
L'administrateur a désactivé l'accès en écriture pour le public.

Survey extremely slow il y a 9 mois 3 semaines #97523

  • jelo
  • Portrait de jelo
  • Hors ligne
  • Platinum Lime
  • Messages : 389
  • Remerciements reçus 40
  • Karma: 15
Which version of Limesurvey is used?
Which database?

Which hoster? Which package?

Perhaps you can attach the surveyfile here or send via private mail?
L'administrateur a désactivé l'accès en écriture pour le public.

Survey extremely slow il y a 9 mois 2 semaines #97540

  • DenisChenu
  • Portrait de DenisChenu
  • Hors ligne
  • Moderator Lime
  • Messages : 5845
  • Remerciements reçus 715
  • Karma: 222
jelo écrit:
Which hoster? Which package?
+1
jelo écrit:
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
L'administrateur a désactivé l'accès en écriture pour le public.

Survey extremely slow il y a 9 mois 2 semaines #97554

  • jelo
  • Portrait de jelo
  • Hors ligne
  • Platinum Lime
  • Messages : 389
  • Remerciements reçus 40
  • Karma: 15
Why is this thread posted under "Development"?

[EDIT="DenisChenu"]Moderate / move to Design issues[/EDIT]
Dernière édition: il y a 9 mois 2 semaines par DenisChenu.
L'administrateur a désactivé l'accès en écriture pour le public.
Cet utilisateur a été remercié pour son message par: DenisChenu
Modérateurs: ITEd
Temps de génération de la page : 0.122 secondes
Donation Image