SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Hybrid View

  1. #1
    SitePoint Enthusiast nnclyn's Avatar
    Join Date
    Dec 2002
    Location
    New Jersey
    Posts
    52
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Oscommerce and slow loading

    I've got a website that uses oscommerce and have been having some slow loading issues on a few products. I've played with removing the flash, changing gzip compression, removing infoboxes..yet none speeds up the load.

    There are two products in particular that are very slow..and I can't find any common denominators there:

    http://thefertilityshop.com/catalog/...products_id=49

    and

    http://thefertilityshop.com/catalog/...roducts_id=114

    The header loads up quickly..the rest of the page..zzzzzzzz

    Any insight? Thanks in advance.

  2. #2
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Turn off Category Counts i.e. Widgets (55)... It is either in the configuration section or application_top.php.

    Also make sure your server is optimized to run MySQL as efficiently as possible. OSCommerce is a query hog so it can slow down the machine. The average front page can have 900 queries on it because the programmers know little about optimization and have queries within loops instead of building datastores and arrays to work from.
    Wayne Luke
    ------------


  3. #3
    SitePoint Enthusiast nnclyn's Avatar
    Join Date
    Dec 2002
    Location
    New Jersey
    Posts
    52
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks. I never used category counts..and the tech that runs my server says that he's optimized my server for mysql.

    Any other thoughts? Thanks

  4. #4
    SitePoint Enthusiast
    Join Date
    Jul 2003
    Location
    Florida
    Posts
    25
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try this contribution, it might help. I have been meaning to give it a shot but just have not gotten around to it.

    http://www.oscommerce.com/community/contributions,1862


    HTH
    Quando Omni Flunkus Moritati...

  5. #5
    SitePoint Enthusiast nnclyn's Avatar
    Join Date
    Dec 2002
    Location
    New Jersey
    Posts
    52
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    After having 3 people try and figure out why only certain products are slow (this one being the biggest culprit: http://thefertilityshop.com/catalog/produc...?products_id=49 )

    We've narrowed down what seems to be the common denominator for the slowest products..and that's that they have reviews. I've tried repairing the reviews tables (although they seemed to be fine). I was looking to see if anyone might have any other input as to what might be going on. The reviews are all clean..just plain text.

    Tried Gzip compression, tried removing the text to see if load time was faster. The headers all load fine..it's what is below the headers that are painfully slow on these products.

    Thank in advance.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •