3 minute load time on start page

[jdogrulz]

Hello all,

 

Can someone help me with this. My site takes 3 minutes to load when you go to it. I thought it was my server, but I complained and they investigated and found that the index page is running 30,000 database queries!, and that it was prestashop causing the problem. I have alot of products, over 6,000 most with photos, but this should not happen.

 

My info:

 

 

Server information

 

Prestashop version: 1.4.5.1

Server information: Linux #1 SMP Tue May 18 17:26:16 MSD 2010 x86_64

Server software version: Apache/2.2.15 (Unix) mod_ssl/2.2.15 OpenSSL/0.9.8e-fips-rhel5 DAV/2 mod_wsgi/2.5 Python/2.4.3 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635

PHP version: 5.2.9

MySQL version: 5.0.95-community

 

Required parameters: OK

Optional parameters: OK

Shop URL:

http://www.biggigifts.com/

 

Please help

 

Thank you

[El Patron]

I don't get anything but connecting...and it's been more than 3 minutes.

Have you contacted your web hosting company?

Is this a new install?

Did it work before?

 

if possible edit your config.config.inc.php, upload to your site root, clear your browser cache, navigate to the site and post any errors and messages. (make sure to restore code after).

change:

@ini_set('display_errors', 'off');
define('_PS_DEBUG_SQL_', false);

 

to

 

@ini_set('display_errors', 'on');
define('_PS_DEBUG_SQL_', true);

[jdogrulz]

Ok, thank you. I will try this and post here.

[jdogrulz]

Sorry I didnt answer your questions.

Have you contacted your web hosting company? - Yes, and I told them of the problems I has having with my server, such as, I have had Name server failures, exim failures, and this happens alot:

chkservd sub-process with pid 3076 was running for 602 seconds. The sub-process was terminated as it exceeded the time between checks of 300 seconds. Please check /var/log/chkservd.log and /usr/local/cpanel/logs/tailwatchd_log to discover the cause.

 

They told me it was not the servers but a Prestashop problem and that the index page had 30,000 databasse queries.

 

Is this a new install? - No, I have had it installed for over a year, but I have not went live yet because of all the bugs.

 

Did it work before? - Yes, worked fine before, but I dont know what happened to make it go bad.

 

Thanks again.

[jdogrulz]

Ok, I found config.inc.php in the config dir and renamed it like you said and put it in the root folder, but that displayed nothing. So I renamed it back to its original name and put it back in the config dir and changed what you said but it did not display any errors???

[Prescol]

Check this:

 

Search the folder: yourprestashop->override->classes and rename the three files by removing the underscore.

 

Now go to the frontend an look under the footer and...Voilá! You have all times that prestashop spend on each task.

[jdogrulz]

thanks I will try that..

[El Patron]

I see that it loads but your get 404 on index...figure you must be working on it...hoping you the best of luck!

[Prescol]

Did you solve it?