This is the third or fourth such report I noticed so we should have a look at this.
I have attached a report of my local version which loads 750KB of data in about 6 seconds for the root page /Limesurvey/index.php/admin/survey/index

coiby-

If you want to insert some timing code yourself, you can use the code in LimeSurveyExpressionManager as a model. See the FinishProcessingPage() function, which processes LEM->runtimeTimings[] that have been collected.

I found this more helpful than using a PHP profiler, since this let me focus on coarse-grained tasks rather than the fine-grained details that are shown by a profiler.

/Tom

Hi Tom,

I'm glad to show runtimeTImings to help you. But how can I enable the output?

It's the admin page no ?

Not the public page, then not EM specific.

Here there are a lot of CSS for display participant, and clearly "js table" are longer the first time.

Denis

coiby-

I meant that someone could follow the example used by LEM-runtimeTimings to calculate timings of other parts of LS to identify the source of the slowdown. EM is effectively identical between 1.92 and 2.0, so I agree that it is unlikely to be the cause.

The screenshot are pretty much meaningless. They are taken with two different tools on two different browsers.

Menno: Would you be interested to have a look at this in general? In general I doubt that 2.0 is 4 times slower as indicated.

Tom: Sorry, I'm not familiar with this and don't have time to follow the example.

c_schmitz: what do you mean by "two different browsers". They are the same! I don't know how much slower 2.0 is than 1.92 exactly. But it's much slower indeed.

Hello,

With the same page, second call (for cache)
http://limesurvey-yii/index.php/admin/user/index : 2.37s (onload: 2.68s),
http://limesurvey/admin/admin.php?action=editusers : 2.5s (onload: 2.95s)

The PHP file waiting:
Yii: 510ms waiting
192 : 210 ms waiting

With Yii : i use blobbluish admin template (Same as 192)

Not able to reproduce slow loading a fresh Xampp for windows installation and on my server. If it really is slow, it must be some kind of server configuration.

I do get 2 404 errors on the downloaded RC4:
GET http://localhost/yii/limesurvey/scripts/jquery/css/jquery.multiselect.css 404 (CHttpException) index:14
GET http://localhost/yii/limesurvey/scripts/jquery/css/jquery.multiselect.filter.css 404 (CHttpException) index:15

Maybe that causes a slow redirect and the delay. Maybe bug owner can verify that these two files are the problem by moving them from /styles-public to /scripts/jquery/css

Hi,

I've moved them from /styles-public to /scripts/jquery/css. But the problem is the same.

Does your server have a public url and if so, could you provide links and login to the admin part? Mark your response as private so only developers can see your response. As none of the devs seems to be able to reproduce, this is the only way we can get some clue on what is wrong.

The URL does not seem to work?

http://www.ipv6proxy.net/ helps a little, but too difficult to see use. To rule out ipv6, could you try on a different location using ipv4?

The survey attached to bug #06534 is a good example. When I test the survey, it loads in 3-4 seconds for LimeSurvey 1.92+, and 22-25 seconds for 2.0RC9.

I highly recommend tracking down the performance issues before saying that 2.0 is stable, since more than about 5 seconds for load time is, in my mind, unacceptable.

The survey from http://bugs.limesurvey.org/view.php?id=6534 uses randomization and executes an insane amount of db queries, when randomization is reset it works at normal speed again. (still showing a lot of duplicate queries though)

for mysql this statement i used to reset the random attributes:
update lsyii__question_attributes set value = '' WHERE attribute LIKE '%rand%' ORDER BY lsyii__question_attributes.value ASC

Don't really have the time to dive into it but who wants to take this bug should look into randomization.

20-25 second is really quite long...

We should either extend the loading time so it takes long enough to get a coffee (and display an according message) or try to fix it.

Carsten will probably be very bored when coming back from holiday so I'll assign this one to him :-)

I'm experiencing the same problem. I just uploaded a couple of surveys that have been extremely slow (sometimes timing out while as few as 10 people are taking it). Also comes up when viewing responses (page will sometimes take up to a minute to load). This is now on a VPS with 4GB memory.

Two other notes: (1) running MySQL queries is very snappy. (2) I'm almost certain this has to do with memory (CPU load has never exceeded .14), as I've seen the server use up to 300MB just pulling up results (a single user). I'm no expert, but this certainly seems excessive. Or am I missing something?

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10263

@seanrife: Some improvements have been done to make surveys with randomization faster. Also a bottleneck with checking for updates has been fixed. Could you please test latest release (121116) and report if it helped to get faster response times so we can close this issue?

Thanks mdekker... I just upgraded, and things seem to be working well. I definitely notice a significant difference. I also (about a week ago) switched to php 5.2.17 and enabled XCache, which seems to have helped too.

All in all, I think we're good to go here. Thanks for all your hard work!