Check out the LimeSurvey source code on GitHub!

mysql query cache / php memcache / apc / etc?

More
6 years 4 months ago #51299 by lovepade
Hi there,

Does anyone have any experience with optimizing performance using any of the mentioned techniques? I realize that this is as much a general question as it is LS specific - I am just nervours about possible caveats and dangeres, when tinkering with setting I don't understand fully.

Theres a sticky thread somewhere about phpsurveyor performing brilliantly - but its old and not really about caching techniques.

I plan to read up on nadeausoftware.com/articles/2007/01/esse...ing_drupal_web_sites and webjawns.com/2010/01/optimize-php-apache...-practices-and-more/

But any pointers from this forums would be great

Thanks in advance and have a splendid day :-)

A

Please Log in to join the conversation.

More
6 years 4 months ago #51307 by mdekker
I have great experience with apache .htaccess like this, makes it fly for me even without other optimisation. This is not failsafe, if the needed modules are not loaded you might get some errors.

Apc or other accelarator is a good idea in general. Read en.wikipedia.org/PHP_accelerator for more info and links.
#Caching
ExpiresActive on
ExpiresByType application/javascript "access plus 1 month"
ExpiresByType text/css "access plus 1 month"
ExpiresByType image/png "access plus 1 month"
ExpiresByType image/jpg "access plus 1 month"
ExpiresByType image/jpeg "access plus 1 month"
ExpiresByType image/gif "access plus 1 month"
ExpiresByType image/ico "access plus 1 month"
ExpiresByType image/x-icon "access plus 1 month" 
 
#Compression
AddOutputFilterByType DEFLATE text/html
AddOutputFilterByType DEFLATE text/css
AddOutputFilterByType DEFLATE application/javascript

---
Menno Dekker

Please Log in to join the conversation.

More
6 years 4 months ago #51390 by lovepade
Wauw - thanks mdekker. Didn't even know about modding .htaccess like that.

The modules I need to copy/paste this is mod_expires and mod_deflate right? I think we have apc enabled, as it was just and install - no settings needed I think.
I think mysql query is the most important one - but thats just a feeling.

Do you, or any other, have pointers as to how I can simulate a big load on the server (for testing purposes)?

Sincerely

Please Log in to join the conversation.

More
6 years 4 months ago #51400 by mdekker
You are right on the apache modules.

For load testing: difficult, as you can only hit a certain page, not simulate clicking though the pages. But for example loadimpact.com/index.php can get you started online with simulated loads. Keep in mind that 50 users hitting your server at the same time is different than having 50 users take a survey and click through pages at varying speeds. There are other tools, like httpd.apache.org/docs/2.0/programs/ab.html but they need some experience to know how to use it right.

So I would say you can have quite a lot of users taking a survey, especially if you are not too heavy on conditions. The array filters seem to cause quite some load on the server somehow.

---
Menno Dekker

Please Log in to join the conversation.

More
6 years 4 months ago #51401 by mdekker
BTW, keep in mind that when you update and the js or css files get updated some browsers still serve the old ones from cache.

---
Menno Dekker

Please Log in to join the conversation.

More
6 years 3 months ago #51429 by lovepade
Thank you, once again. I can't figure out if seleniumhq.org/ can help with a realistic click-through scenario.

The tweaking takes place saterday. hopefully I wont break anything :-)

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form