Loading Issue again

shahed · December 4, 2002

Ok, I been running my site for 2 months with Oscommerce, its going good. I also moved to a new server for better performance(its a shared server though). here is my site :

http://bdbazar.com/nshop

Now I think site is slow still, not only the frontpage, all other pages, even the page with no images. take a look at this one:

http://bdbazar.com/nshop/product_info.php/...roducts_id/1126

Ok here is some info about my server load:

http://sjhosting1.com/stats.php

Guys I have hosting from 2/3 reseller(Mchost etc type), do you guys think I should move my e-commerce hosting to a big company hosting like Verio? or other big one? I need advice

Shahed

Ajeh · December 4, 2002

I hate to say this but that really stinks ... :shock:

I am on an extreamly fast DSL connection and I could get a cup of coffee while waiting.

Did you change anything other than move the site?

Have you thought about moving the site again? :roll:

shahed · December 4, 2002

Linda I know it stinks now, I took care taking out category counting but helping much.

My other sites which are using mysql are lot faster, so I really dont know..

rseigel · December 4, 2002

Cable here and it's sloooooooooooooooooooooooooooowwwwwwww for me as well. :shock:

Cappuccino anyone? :sleepy:

shahed · December 4, 2002

sloooooooooooooooooooooooooooowwwwwwww for me as well. :shock:

I would like to get some idea, not sympathy ... is it for hosting or Oscommerce

rseigel · December 4, 2002

Well excuuuuuse me.

My site is lightning fast (1000+ products and counting is ON) so I'd say it's not an OSC issue.

Looks like it's time to start host shopping again.

shahed · December 4, 2002

hmm.. I will but here is another page loads little faster:

http://bdbazar.com/nshop/shipping.php

Let me know guys..

What are big option for hosting, do not post any reseller hosting(currently I'm one) .. beside Verio ...

rseigel · December 4, 2002

http://webhostingtalk.com/

More hosts than you can shake a stick at.

Every time someone asks about hosting here these so-called OSC hosts come out of the woodwork to tell you how great they are. Truth is most of them are worthless that I've seen here. Webhostingtalk will give you a less biased view of hosts in general than you could ever hope to get here.

Ajeh · December 4, 2002

Still a good 5 seconds. Mainly it is faster as that page is not doing as much as the others. But it is still pretty bad.

Did you check the speed differences of the two hosting companies to see if one is offering faster servers? faster lines? etc.?

I have really not come across a site this slow.

I am not in anyway into setting up servers, so I really cannot begin to suggest questions to query your hosting site about. But this is the server not osC from what I can see.

shahed · December 4, 2002

Still a good 5 seconds. Mainly it is faster as that page is not doing as much as the others. But it is still pretty bad.

Did you check the speed differences of the two hosting companies to see if one is offering faster servers? faster lines? etc.?

I have really not come across a site this slow.

I am not in anyway into setting up servers, so I really cannot begin to suggest questions to query your hosting site about. But this is the server not osC from what I can see.

Linda I compared many hosting company and came upto this one, it was faster than before but all of a sudden it slows since last week.

I just want to make sure before I move, it takes lots of effort to move actually. and this is a holiday time for me.

Ajeh · December 4, 2002

Try something ... turn off all your banners.

I had this break on me for a week where the banners being served up by the banner company were causing this to happen.

After a week or two it was fixed.

shahed · December 4, 2002

Try something ... turn off all your banners.

I had this break on me for a week where the banners being served up by the banner company were causing this to happen.

After a week or two it was fixed.

what is the easiest way of turning the banner? edit footer.php?

Ajeh · December 4, 2002

Comment them out? :shock:

Or, back up your /includes/footer.php and cut out of it at the bottom:

<?php

 if ($banner = tep_banner_exists('dynamic', '468x50')) {

?>

<br>

<table border="0" width="100%" cellspacing="0" cellpadding="0">

 <tr>

   <td align="center"><?php echo tep_display_banner('static', $banner); ?></td>

 </tr>

</table>

<?php

 }

?>

shahed · December 4, 2002

banner is turned off, I dont think its code, I think its Mysql Connection.. It sucks.. Gotta move it to a big reliable company

shahed · December 4, 2002

This is my code for Category.php , is it still counting? Just curious

/*

 $Id: categories.php,v 1.1 2002/08/31 11:13:09 wilt Exp $



 osCommerce, Open Source E-Commerce Solutions

 http://www.oscommerce.com



 Copyright (c) 2002 osCommerce



 Released under the GNU General Public License

*/



 function tep_show_category($counter) {

   global $foo, $categories_string, $id;



   for ($a=0; $a<$foo[$counter]['level']; $a++) {

     $categories_string .= "  ";

   }



   $categories_string .= '<a href="';



   if ($foo[$counter]['parent'] == 0) {

     $cPath_new = 'cPath=' . $counter;

   } else {

     $cPath_new = 'cPath=' . $foo[$counter]['path'];

   }



   $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new);

   $categories_string .= '">';



   if ( ($id) && (in_array($counter, $id)) ) {

     $categories_string .= '<b>';

   }



// display category name

   $categories_string .= $foo[$counter]['name'];



   if ( ($id) && (in_array($counter, $id)) ) {

     $categories_string .= '</b>';

   }



   



   $categories_string .= '</a>';



   if (SHOW_COUNTS == 'true') {

     $products_in_category = tep_count_products_in_category($counter);

     if ($products_in_category > 0) {

     //  $categories_string .= ' (' . $products_in_category . ')';

     }

   }



   $categories_string .= '<br>';



   if ($foo[$counter]['next_id']) {

     tep_show_category($foo[$counter]['next_id']);

   }

 }

rseigel · December 4, 2002

What about the GeoTrust button? Try yanking that out and see if it makes a difference (I assume that the image is being called from their server?).

shahed · December 4, 2002

Thanks Linda, I already did . Complete category.php is here

<?php

/*

 $Id: categories.php,v 1.1 2002/08/31 11:13:09 wilt Exp $



 osCommerce, Open Source E-Commerce Solutions

 http://www.oscommerce.com



 Copyright (c) 2002 osCommerce



 Released under the GNU General Public License

*/



 function tep_show_category($counter) {

   global $foo, $categories_string, $id;



   for ($a=0; $a<$foo[$counter]['level']; $a++) {

     $categories_string .= "  ";

   }



   $categories_string .= '<a href="';



   if ($foo[$counter]['parent'] == 0) {

     $cPath_new = 'cPath=' . $counter;

   } else {

     $cPath_new = 'cPath=' . $foo[$counter]['path'];

   }



   $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new);

   $categories_string .= '">';



   if ( ($id) && (in_array($counter, $id)) ) {

     $categories_string .= '<b>';

   }



// display category name

   $categories_string .= $foo[$counter]['name'];



   if ( ($id) && (in_array($counter, $id)) ) {

     $categories_string .= '</b>';

   }



   



   $categories_string .= '</a>';



   if (SHOW_COUNTS == 'true') {

     $products_in_category = tep_count_products_in_category($counter);

     if ($products_in_category > 0) {

     //  $categories_string .= ' (' . $products_in_category . ')';

     }

   }



   $categories_string .= '<br>';



   if ($foo[$counter]['next_id']) {

     tep_show_category($foo[$counter]['next_id']);

   }

 }

?>

<!-- categories //-->

         <tr>

           <td>

<?php

 $info_box_contents = array();

 $info_box_contents[] = array('align' => 'left',

                              'text'  => BOX_HEADING_CATEGORIES

                             );

 new infoBoxHeading($info_box_contents, true, false);



 $categories_string = '';



 $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . $languages_id ."' order by sort_order, cd.categories_name");

 while ($categories = tep_db_fetch_array($categories_query))  {

   $foo[$categories['categories_id']] = array(

                                       'name' => $categories['categories_name'],

                                       'parent' => $categories['parent_id'],

                                       'level' => 0,

                                       'path' => $categories['categories_id'],

                                       'next_id' => false

                                      );



   if (isset($prev_id)) {

     $foo[$prev_id]['next_id'] = $categories['categories_id'];

   }



   $prev_id = $categories['categories_id'];



   if (!isset($first_element)) {

     $first_element = $categories['categories_id'];

   }

 }



 //------------------------

 if ($cPath) {

   $id = split('_', $cPath);

   reset($id);

   while (list($key, $value) = each($id)) {

     $new_path .= $value;

     unset($prev_id);

     unset($first_id);

     $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . $value . "' and c.categories_id = cd.categories_id and cd.language_id='" . $languages_id ."' order by sort_order, cd.categories_name");

     $category_check = tep_db_num_rows($categories_query);

     while ($row = tep_db_fetch_array($categories_query)) {

       $foo[$row['categories_id']] = array(

                                           'name' => $row['categories_name'],

                                           'parent' => $row['parent_id'],

                                           'level' => $key+1,

                                           'path' => $new_path . '_' . $row['categories_id'],

                                           'next_id' => false

                                          );



       if (isset($prev_id)) {

         $foo[$prev_id]['next_id'] = $row['categories_id'];

       }



       $prev_id = $row['categories_id'];



       if (!isset($first_id)) {

         $first_id = $row['categories_id'];

       }



       $last_id = $row['categories_id'];

     }

     if ($category_check != 0) {

       $foo[$last_id]['next_id'] = $foo[$value]['next_id'];

       $foo[$value]['next_id'] = $first_id;

     }



     $new_path .= '_';

   }

 }



 tep_show_category($first_element); 



 $info_box_contents = array();

 $info_box_contents[] = array('align' => 'left',

                              'text'  => $categories_string

                             );

 new infoBox($info_box_contents);

?>

           </td>

         </tr>

<!-- categories_eof //-->

Ajeh · December 4, 2002

Heck was just about to enter the GeoTrust button ... good thought there :D

If SHOW_COUNTS is defined as false then there should not be counting there.

shahed · December 4, 2002

What about the GeoTrust button? Try yanking that out and see if it makes a difference (I assume that the image is being called from their server?).

Ok now everything is gone from both side and take a look at this one :

http://bdbazar.com/nshop/product_info.php/.../products_id/35

Still hell slow.. I gotta ask my hosting about their mysql I guess

Ajeh · December 4, 2002

Give them a chance to fix things ... could be a bad hair day ... *cough* week ... :shock:

Good luck! :D

shahed · December 4, 2002

Give them a chance to fix things ... could be a bad hair day ... *cough* week ... :shock:

Good luck! :D

Thanks for ur help

shahed · December 4, 2002

Linda

I get this response from Admin from my server:

"I also checked the load on the server to be sure nothing is wrong..

mysql.xxx.com 0.65, 0.60, 0.56 12 days, 5:22

mysql1.xxx.com 0.00, 0.00, 0.00 1 day, 5:32

"

So problem is there, I just to make sure there is nothing to do with code, what about Indexing..?

shahed · December 4, 2002

anyone willing to help, any professional Help also welcome, PM me your rate

December 4, 2002

Hi Shahed,

Although I don' t seem to see where your problem might be as your site loads like lighting fast from my PC, I recall that once I had a problem of a slow loading site, I solved my problem by switching RECURSIVE_COUNT to FALSE in application_top.php, and changing my primary and index Keys in mySql tables.

There is a contrib that could help you do that http://www.oscommerce.com/downloads.php/co...ions,684/type,5.

Hope this helps, and let us know what happens.

Good Luck

Mark Evans · December 4, 2002

do you guys think I should move my e-commerce hosting to a big company hosting like Verio? or other big one? I need advice

I would recommend getting away from a shared server and using a dedicated server for your e-commerce.

Loading Issue again

Recommended Posts

shahed

Ajeh

shahed

rseigel

shahed

rseigel

shahed

rseigel

Ajeh

shahed

Ajeh

shahed

Ajeh

shahed

shahed

rseigel

shahed

Ajeh

shahed

Ajeh

shahed

shahed

shahed

Guest

Mark Evans

Archived

Browse

Activity