Server waiting time

[razvy]

What has to be done on server side in order to reduce the waiting time?

 

I have read all the speed topics on this forum and they are all great resources, but I have a specific issue that none addressed: the waiting time of the server.

 

For example: I run a word search on my store and the loading time of the result page is 22 seconds, from wich more than 20 seconds is the waiting time of the server. From what I understand, this is the time needed for the server to prepare the page before sending it back to the browser.

 

Of course, the test is a little tough, I have 30.000 products (from wich only 10.000 active) and there are about 400 that comply with the search.

 

I have made different tests and changed a few hosting plans, from shared to VPS with 3 GB RAM. I tried with different webservers (Apache, Litespeed) and different caching systems (memcache, APC) => there is no visible change, each one is taking about 20 seconds to render the page. In fact, the cache shouldn't speed things up, unless someone has already searched for the same word, but this is not the point of my question.

 

My conclusion is there are is something with the way Prestashop (1.6.1.1) is handling the queries or there are some patameters that have to be changed on the server configuration.

 

Do you have any idea of what should be done in order to speed things up?

 

Thanks!

[selectshop.at]

Please use the search function of the forum. This is a hot discussed thematic.

 

Server configuration - official doc: http://doc.prestashop.com/display/PS16/System+Administrator+Guide#SystemAdministratorGuide-Requiredsettings

Server configuration - best performance according to experience:

 

PS 1.5.X + PS 1.6 X

• magic_quotes_gpc = off
• memory_limit = 256M (ideal: 512M - PS 1.6.)
• max_execution_time = 300
• max_input_time = 300
• upload_max_filesize = 20M
• post_max_size = 20M
• max_input_vars = 10000
• allow_url_fopen = on
• safe_mode = off
• cURL - installed
• mod_rewrite = installed
• mod_security = off
• php 5.3 or higher (for PS 1.6. best php 5.4.5 or higher) - for PS 1.7. at least 5.4.
• mySQL 5.5 or higher
• LINUX server
• cageFS or other server sidede firewall disabled or well configured to don't block services Prestashop is calling from outside

PS 1.7.X - further to min configuration for PS 1.5/1.6 there is the need of:

• PHP best versions over phph 5.5.9
• memory_limit = 512 M
• JSON = ON
• ctype = ON
• mySQL machine = INNODB (myIsam does not work correctly)
• php-fpm disabled
• php.ini needs to have date.timezone configured (several providers do not configure this, for to be more flexible on selling their webspace)