Very slow responce between category pages

[gregor92]

I'm having very slow page loads when choosing between categories.

 

I've done all the performance options recommended except for the "High Risk HTML compression". I've also had my host change the mysql cache with no change in speed.

 

CMS pages seem to load fine, but when ever there is a database query involved the page loads take about 6 seconds.

 

Any help would be appreciated.

 

Here is the url: http://lisaslist.mob

[Mike Kranzler]

I'm having very slow page loads when choosing between categories.

 

I've done all the performance options recommended except for the "High Risk HTML compression". I've also had my host change the mysql cache with no change in speed.

 

CMS pages seem to load fine, but when ever there is a database query involved the page loads take about 6 seconds.

 

Any help would be appreciated.

 

Here is the url: http://lisaslist.mob

 

Hi gregor,

Please check your website URL, it doesn't seem to work on our end.

 

-Mike

[gregor92]

Hi gregor,

Please check your website URL, it doesn't seem to work on our end.

 

-Mike

 

 

Sorry, here it is: http://lisaslist.mobi/

[Mike Kranzler]

Hi gregor,

This appears to be an issue with your hosting provider. Who hosts your site?

 

-Mike

[gregor92]

Hi gregor,

This appears to be an issue with your hosting provider. Who hosts your site?

 

-Mike

 

http://www.networkredux.com/

 

I also migrated from a Yahoo Shop using http://www.shopping-cart-migration.com/

I'm hoping they didn't cause any data problems.

[Mike Kranzler]

Hi gregor,

Cart2Cart's service shouldn't cause any issues, but my concern is with your hosting provider. You may want to compare their offerings with PrestaShop's system requirements, and perhaps consider switching to one of the options at the bottom of that page under "Choose a Hosting" if your current host doesn't stack up.

 

-Mike

[gregor92]

Hi gregor,

Cart2Cart's service shouldn't cause any issues, but my concern is with your hosting provider. You may want to compare their offerings with PrestaShop's system requirements, and perhaps consider switching to one of the options at the bottom of that page under "Choose a Hosting" if your current host doesn't stack up.

 

-Mike

 

 

My host seems to have all the requitments met. Is there any thing they should be looking at in particular?

 

Apache

PHP/5.2.17

MySQL 5.1.63

memory_limit 128M

MemCached = enabled

mcrypt = enabled

[Mike Kranzler]

My host seems to have all the requitments met. Is there any thing they should be looking at in particular?

 

Apache

PHP/5.2.17

MySQL 5.1.63

memory_limit 128M

MemCached = enabled

mcrypt = enabled

 

It's possible their servers are just overloaded. You may want to give them a call to see what they would suggest that you do.

 

-Mike

[gregor92]

It's possible their servers are just overloaded. You may want to give them a call to see what they would suggest that you do.

 

-Mike

 

These are the recommendations from my host:

 

-------- Recommendations -----------------------------------------------------

General recommendations:

Run OPTIMIZE TABLE to defragment tables for better performance

Reduce your overall MySQL memory footprint for system stability

Adjust your join queries to always utilize indexes

Set thread_cache_size to 4 as a starting value

Increase table_cache gradually to avoid file descriptor limits

Your applications are not closing MySQL connections properly

Variables to adjust:

*** MySQL's maximum memory usage is dangerously high ***

*** Add RAM before increasing MySQL buffer variables ***

query_cache_size (>= 8M)

join_buffer_size (> 128.0K, or always use indexes with joins)

thread_cache_size (start at 4)

table_cache (> 64)

innodb_buffer_pool_size (>= 24M)

-------------------------------------------------------------------------------------------------

 

How can these item get accomplished?

[Mike Kranzler]

Hi gregor,

These all appear to be server-side recommendations, meaning that they should be able to handle these for you, or at least tell you how to do them (as they aren't commands that are part of PrestaShop's software).

 

If they can't handle this though, I would still suggest you switch to a more compatible hosting provider, like BlueHost.

 

-Mike

[gregor92]

Hi gregor,

These all appear to be server-side recommendations, meaning that they should be able to handle these for you, or at least tell you how to do them (as they aren't commands that are part of PrestaShop's software).

 

If they can't handle this though, I would still suggest you switch to a more compatible hosting provider, like BlueHost.

 

-Mike

 

I've created an account with BlueHost and have replicated my DB there. I've also changed the settings.inc.php on my current server.

 

define('_DB_SERVER_', '66.147.244.240');

 

Also, updated DB_NAME, DB_USER & DB_PASSWD.

 

I also added the Remote Mysql Database Access on BlueHost:74.63.6.106

 

However I'm getting the following error accessing the site:

Link to database cannot be established.

 

Any ideas?

[Mike Kranzler]

Have you followed all of the steps to moving your store here?

 

-Mike

[gregor92]

Have you followed all of the steps to moving your store here?

 

-Mike

 

Changing categories is still slow on BlueHost. I've tried and searched everywhere for a solution but can't get this issue resolved.

 

http://66.147.244.24...p?id_category=2

 

 

I've narrowed this down to just a few lines of code. They all have to do with the function Module::hookExec().

 

If i comment out the following the lag is eliminated:

 

CategoryControler.php:

 

Module::hookExec('productListAssign', array('nbProducts' => &$this->nbProducts, 'catProducts' => &$this->cat_products, 'hookExecuted' => &$hookExecuted));

 

FrontControler.php:

 

self::$smarty->assign(array(

'HOOK_HEADER' => Module::hookExec('header'),

'HOOK_TOP' => Module::hookExec('top'),

'HOOK_LEFT_COLUMN' => Module::hookExec('leftColumn')

));

 

I also have the smarty debug window active if this provides any useful information.

 

http://lisaslist.mobi/3-pillows-throws

 

Thanks

Edited July 7, 2012 by gregor92 (see edit history)