EricPrice Posted January 27, 2003 Share Posted January 27, 2003 I've done a search but cant seem to find anything relavent to my problem so... Ive got a site configured on a box that, on occasion, seems to hang when loading a particular page. It doesnt matter which page. This seems to happen both in the admin sections and the regular catalog. The page eventually loads, but I am sure the delay would send customers scurrying to another site. The server is more than adequate and isnt being taxed in any way. I could provide specific details if needed. Its Redhat Linux with Apache webserver and PHP 4.3 and MySQL all on the same box. Web traffic to the box is minimal. Caching is enabled in the admin section. Sessions arent stored in the db. Does anyone have any ideas? What additional info do I need to provide? Link to comment Share on other sites More sharing options...
vonbrocklin Posted February 22, 2003 Share Posted February 22, 2003 I get the same thing. Seemingly random. The site will be zipping along and will suddenly hang for 15-20 seconds before loading. An hour later, the same page will pop right up. It is not my connection or the server, because other sites on the same server zoom right along during these times. Is this a commom problem? Link to comment Share on other sites More sharing options...
jackof Posted March 1, 2003 Share Posted March 1, 2003 Hello there, Have anybody else found the solution for this problem? I too having the same problem. I installed a new version and just deleted all the categories-products-manufacturers. Added few categories, products and manufactureres and when i see my hope page, it only loads till the header of 'New products for feb'. No products are seen :( . Please help me if anybody else have found a solution to this. Thanks in advance Best Regs, Jack Link to comment Share on other sites More sharing options...
Javier Posted March 1, 2003 Share Posted March 1, 2003 I'm having the same problems at times. I even tried using different computers just to see if its my computer that is causing the slowness, but its not!! :evil: Link to comment Share on other sites More sharing options...
mattice Posted March 1, 2003 Share Posted March 1, 2003 You say it is not the site speed. Could it be the mysql speed? What (possibly) happens is osCommerce does a query on the database which at that moment is extremely busy, hence the extra seconds. Comparing it to other sites on the same server is only valueable if they too run osCommerce. HTH Mattice "Politics is the art of preventing people from taking part in affairs which properly concern them" Link to comment Share on other sites More sharing options...
jackof Posted March 1, 2003 Share Posted March 1, 2003 i run many application on local machine (for testing purpose) but non of them behave this way. I m sure there's some problem in the 'new_products.php' file. I believe the process gets killed when quering for new products in the database. I'm a beginner, so nothing much i can do. Any light from the core team would help us. Best Regs, Jack Link to comment Share on other sites More sharing options...
mattice Posted March 1, 2003 Share Posted March 1, 2003 The team runs test shops continuously but I've not seen this complaint before (only when counting was on / caching was off). What are the exact system specs of the machine? "Politics is the art of preventing people from taking part in affairs which properly concern them" Link to comment Share on other sites More sharing options...
jackof Posted March 1, 2003 Share Posted March 1, 2003 i m running apache on winXP with the following installed Php - 4.0.5 Mysql - 3.23.37 Best Regs, Jack Link to comment Share on other sites More sharing options...
Guest Posted March 9, 2003 Share Posted March 9, 2003 I sort of had the same problem. The pages occassionally didn't load at alll and sometimes the footer and parts of nav bars were missing. I realized that it had to do with storing sessions with mysql. I had this enabled, but when I disabled it everything was fine. Try it out and see what happens! Link to comment Share on other sites More sharing options...
Guest Posted April 5, 2003 Share Posted April 5, 2003 Fixed it for me!! Link to comment Share on other sites More sharing options...
Guest Posted April 5, 2003 Share Posted April 5, 2003 The easiest fix for these problems is to install MySQL 4.0.12 and enable query caching... Other fixes include optimizing your database. OSCommerce, doesn't utilize indexes properly on the tables nor is there denormalization for speed and resources. Link to comment Share on other sites More sharing options...
Guest Posted April 5, 2003 Share Posted April 5, 2003 Well, certainly, that would be the best solution. Some of us are held hostage by our hosting providers, however. Mine is pretty liberal, and I can always compile my own shell of PHP and run it as a CGI, but that would only complicate matters. They did indicate they are moving to the new releases of PHP and MySQL soon, so I'm happy. This fix with the sessions really added a lot of speed to my site in addition to fixing my bigger problem of pages not loading properly. OSCOMMERCE ROCKS! 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.