d0mokun Posted February 7, 2007 Share Posted February 7, 2007 Hi chaps, I've been running an osC platform for about a year now and have had no problems. Recently the whole system has started running slowly.. I mean, really, *really* slowly. It's taking up to times of a minute to load the initial store front, and then hefty times for anything else. The admin panel runs as smoothly and as fast as ever, that's what I don't get. When visiting the store, the browser attempts to connect to some sort of SSL website. I know for a fact that we are not running anything to do with the SSL site mentioned.. the store is not configured to use SSL either. Any help would be gratefully received. Kindest regards Dan. Link to comment Share on other sites More sharing options...
Guest Posted February 7, 2007 Share Posted February 7, 2007 This is interesting...I have noticed a very distinct slowdown in the past 2 to 3 days with my test OSCommerce (Stock out of the box).. hummmmmmmmmmm SteveRF Link to comment Share on other sites More sharing options...
jasonabc Posted February 7, 2007 Share Posted February 7, 2007 Difficult to give any advice without seeing a URL..... Jason My Contributions: Paypal Payflow PRO | Rollover Category Images | Authorize.net Invoice Number Fix Link to comment Share on other sites More sharing options...
d0mokun Posted February 7, 2007 Author Share Posted February 7, 2007 Sorry mate I forgot that bit: http://www.alphasim3.com/store TIA. Dan. EDIT- xrampssl is the thing that tries to load.. but I've never heard of it? Link to comment Share on other sites More sharing options...
jonquil Posted February 7, 2007 Share Posted February 7, 2007 This is in your header.php: <script language="JavaScript" src='https://www.XRampSSL.com/Secure/javascript/trustlogo.js'> </script> jon It's all just ones and zeros.... Link to comment Share on other sites More sharing options...
d0mokun Posted February 7, 2007 Author Share Posted February 7, 2007 This is in your header.php: <script language="JavaScript" src='https://www.XRampSSL.com/Secure/javascript/trustlogo.js'> </script> jon Hi Jon, Many thanks for digging that up.. I'll get rid of it and see if it works. Thanks. Dan. EDIT- Works a treat.. thanks mate. Link to comment Share on other sites More sharing options...
jonquil Posted February 7, 2007 Share Posted February 7, 2007 Wow, way faster loading! Just check with your host about how that js from xramp relates to your SSL. jon It's all just ones and zeros.... Link to comment Share on other sites More sharing options...
d0mokun Posted February 8, 2007 Author Share Posted February 8, 2007 Will do! Thanks again Jon. Link to comment Share on other sites More sharing options...
jayblaq Posted February 8, 2007 Share Posted February 8, 2007 your database might be filling up to with keywords i delete the dumping data in the table keywords_search and it made my site run 50% faster Link to comment Share on other sites More sharing options...
asapcustoms Posted February 8, 2007 Share Posted February 8, 2007 JAYBLAG Could you give us some tips on this. We are running very slow at www.asapcustoms.com/catalog/index.php Other pages load faster like We are running very slow at www.asapcustoms.com/catalog/wishlist.php The index.php and categories to show take forever to load. We have about 15K items. Thx Link to comment Share on other sites More sharing options...
Rachael w. Posted February 8, 2007 Share Posted February 8, 2007 I have three osc sites on one server and they are all crawling also. I thought it was that the tables were filling up because the sessions, whos online and customer basket tables had 'overflowed' so I deleted the info in those tables and it didnt help. I also removed the rss feed from the one site, didnt help much. My server is now running on %99.56 full (of 1gb) ram...I cant figure out what is using so much ram. Somehow even though they are crawling for me, I have been having sales so it doesnt seem to be bothering too many people, maybe they all just think its their computer rather than my site. This is a topic I am following closely. Link to comment Share on other sites More sharing options...
Guest Posted February 8, 2007 Share Posted February 8, 2007 there are some threads in the tips and trics forum and contributions to optimize the store. Check for cache. Personally I would cache the sql queries for a store with many categories/products and utilize spiders visits to clean up tables. Link to comment Share on other sites More sharing options...
jayblaq Posted February 8, 2007 Share Posted February 8, 2007 JAYBLAG Could you give us some tips on this. We are running very slow at www.asapcustoms.com/catalog/index.php Other pages load faster like We are running very slow at www.asapcustoms.com/catalog/wishlist.php The index.php and categories to show take forever to load. We have about 15K items. Thx This will make your search speed and product displays fly IN advanced_search Comment this out: //$where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%'"; Simply change to this: $where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%'"; I have also emptied the table for keywords_search and that helped. If your running a phpbb forum you will want to take a look and empty of the of tables there too Link to comment Share on other sites More sharing options...
asapcustoms Posted February 8, 2007 Share Posted February 8, 2007 JAYBLAG I found the following about indexes. Would you recommend running this on my phpmyadmin DB area? alter table categories add index (sort_order); alter table customers add index (customers_email_address); alter table orders add index (customers_id); alter table products add index (products_model), add index (products_price), add index (products_date_available), add index (manufacturers_id); alter table products_attributes add index (products_id), add index (options_id); alter table products_options add index (products_options_name); I have not done indexes since starting the site 18 months back. Thank You Steve ASAP Customs :thumbsup: Link to comment Share on other sites More sharing options...
jayblaq Posted February 8, 2007 Share Posted February 8, 2007 JAYBLAG I found the following about indexes. Would you recommend running this on my phpmyadmin DB area? alter table categories add index (sort_order); alter table customers add index (customers_email_address); alter table orders add index (customers_id); alter table products add index (products_model), add index (products_price), add index (products_date_available), add index (manufacturers_id); alter table products_attributes add index (products_id), add index (options_id); alter table products_options add index (products_options_name); I have not done indexes since starting the site 18 months back. Thank You Steve ASAP Customs :thumbsup: indexing your database will help! just make sure its the right indexing... where did this come from? Link to comment Share on other sites More sharing options...
Rachael w. Posted February 8, 2007 Share Posted February 8, 2007 what is indexing and how does it help? Link to comment Share on other sites More sharing options...
Guest Posted February 8, 2007 Share Posted February 8, 2007 This will make your search speed and product displays fly IN advanced_search Comment this out: //$where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%'"; Simply change to this: $where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%'"; I have also emptied the table for keywords_search and that helped. If your running a phpbb forum you will want to take a look and empty of the of tables there too I've seen this before, so what makes you think that if you change the search code will optimize the product pages? Has nothing to do with it. And there is no keywords_search table with the default osc. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.