jorgecrce Posted December 28, 2014 Share Posted December 28, 2014 Hello, I have an prestashop store (www.herbolariosiempreviva.com) and I'm not able to improve the response time of the server, which uses to be between 2 and 4 seconds. I have a shared hosting in OVH, and I have recently moved from profesional to Performance 1 plan, and I moved the database to the 128Mb private MySQL server. I have also activated all the Prestashop performance options; Smarty cache, CCC and 3 media servers. I think that is or a problem of PHP or a problem of MySQL, because I have load to the server a simple HTML (http://herbolariosiempreviva.com/prueba.html) and it loads without these hight waiting times. I have the default options of PHP-FPM of OVH (http://guias.ovh.es/OptimizacionPhpFpm) And about the MySQL, here is the my.cnf file: " [mysqld] tmp_table_size=16M query_cache_size=32M thread_cache_size=5 max_connections=50 open_files_limit=900 skip-locking key_buffer_size = 32M max_allowed_packet = 1M table_cache = 300 table_open_cache = 600 sort_buffer_size = 1M join_buffer_size = 2M read_buffer_size = 512K read_rnd_buffer_size = 256K #net_buffer_length = 2K thread_stack = 128K max_binlog_cache_size = 1M max_join_size = 12M max_seeks_for_key = 2M max_write_lock_count = 512K myisam_max_sort_file_size = 1M ######################## ##Configuration Innodb## ##Uncomment the next line to disable Innodb #skip-innodb innodb_buffer_pool_size = 16M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 10M innodb_log_buffer_size = 4M innodb_flush_log_at_trx_commit=1 skip-name-resolve " Thanks for any help! Link to comment Share on other sites More sharing options...
El Patron Posted December 28, 2014 Share Posted December 28, 2014 edit file config/defines.inc.php change the following to true define('_PS_DEBUG_PROFILING_', false); visit slow page(s), collect information at bottom of page this will help you find where shop back is slow note: this will activate profiling for all visitors so use with caution front and back. Link to comment Share on other sites More sharing options...
jorgecrce Posted December 28, 2014 Author Share Posted December 28, 2014 Ok, but I have no idea about how to interpret that. It says that better use a toaster Link to comment Share on other sites More sharing options...
jorgecrce Posted December 28, 2014 Author Share Posted December 28, 2014 I have tried to deactivate modules in order to have less SQL queryes. I have arrive to have around 150 queryes and 0.5s of time querying, but the response time has continued being the same. Any ideas? Link to comment Share on other sites More sharing options...
Dh42 Posted December 29, 2014 Share Posted December 29, 2014 Slow server? What is your host and plan. Link to comment Share on other sites More sharing options...
JPresta.com Posted December 29, 2014 Share Posted December 29, 2014 Server response time is not the only thing to optimize, see what GTMetrix detected like your images that are not scaled, some 404 image URL, etc. You may also reduce the number of products displayed on home page or use an HTML cache module. Link to comment Share on other sites More sharing options...
jorgecrce Posted December 29, 2014 Author Share Posted December 29, 2014 Hh42: I have write that in my first message. I have a shared hosting, OVH Performance 1. JoeMartin: I just email you yesterday asking about a free trial of your module, and you told me that I have 30 days money back to test it . I'll try what you say for now. Based on your experience, do you think that your module is appropriate for my web? Link to comment Share on other sites More sharing options...
JPresta.com Posted December 30, 2014 Share Posted December 30, 2014 I'll try what you say for now. Based on your experience, do you think that your module is appropriate for my web? Sure it is! PageCache speeds up all stores, even if you have a powerful server it will be even faster and allow you more simultaneous visitors. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now