Slow Page Loads

[tfittsy]

I noticed my orders have slowed down the last few days and when visiting my website I find that some pages have slowed to a crawl. The checkout_shipping.php page usually takes more than 12 seconds to load.

 

I did some debugging and found this:

 

for ($i=0; $i<$size; $i++) {

$quotes = $GLOBALS[$include_quotes[$i]]->quote($method); //this is the line

if (is_array($quotes)) $quotes_array[] = $quotes;

 

}

 

that code is loacated in the shipping.php class

 

the line commented with //this is the line takes about 4 seconds for each shipping module to load. What's strange is that I have another store on the very same server (it uses another database and another directory of shipping modules, but they're all the same files) and it loads instantly. Thanks for any help.

[boxtel]

I noticed my orders have slowed down the last few days and when visiting my website I find that some pages have slowed to a crawl. The checkout_shipping.php page usually takes more than 12 seconds to load.

 

I did some debugging and found this:

 

for ($i=0; $i<$size; $i++) {

$quotes = $GLOBALS[$include_quotes[$i]]->quote($method); //this is the line

if (is_array($quotes)) $quotes_array[] = $quotes;

 

}

 

that code is loacated in the shipping.php class

 

the line commented with //this is the line takes about 4 seconds for each shipping module to load. What's strange is that I have another store on the very same server (it uses another database and another directory of shipping modules, but they're all the same files) and it loads instantly. Thanks for any help.

 

that line gets the quotes of each individual shipping module so I assume that one of those modules may be the cause.

Maybe that module fetches info from external sources and that takes a while.

[tfittsy]

that line gets the quotes of each individual shipping module so I assume that one of those modules may be the cause.

Maybe that module fetches info from external sources and that takes a while.

 

 

I figured it out. It had to do with the quantity price breaks mod. For some reason it was returning like 15,000 rows on a query instead of one so I just tracked down the query and limited it to 1 and now all my problems are gone. Thanks for the help though.