Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 4 of 4

Thread: Slow Page Loads on Backend (splash.aspx, orders.aspx, and customers.aspx)

  1. 07-05-2013, 10:15 AM #1
    acting_andy is offline Junior Member
    Join Date
    Jul 2010
    Location
    Albany, NY
    Posts
    7

    Unhappy Slow Page Loads on Backend (splash.aspx, orders.aspx, and customers.aspx)

    We have three pages that take an exceedingly long time to load, with the exception of these pages the rest of the site performs well. The three pages are spalsh.aspx, orders,aspx, and customers.aspx.

    We have reached out to our hosting company and worked on trouble shooting including increasing our memory, defragging our database, looking in to CPU/Memory/Network usage, and connectivity between the two machines (Web Server and Database Server) with no apparent cause as everything is coming up clean and in working order or resolution.

    I used Google Chrome's Development Tools (F12) to watch how it's loading and came up with these results
    Connecting: 138 ms
    SSL: 120 ms
    Sending: 0
    Waiting: 40.97s
    Receiving: 59ms

    Any idea what would cause waiting to be so long? We have been dealing with this for a month and a half and are no closer to a solution.

    Thank you for any help!

    Andrew
  2. 07-08-2013, 06:17 AM #2
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    You would probably need to set up a SQL Profiler trace on the database and open each of those page individually. This will give you all of the SQL statements that are running when you open the page. There will be quite a few! Then extract out each of those statements and run them against the database. This could give you an idea of which is running slowly. You could be suffering from the dbo.profile table getting too big - it has been reported here in this forum previously.

    Or, sounds like there's an index missing on the customer or orders tables.
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!
  3. 07-08-2013, 12:13 PM #3
    mmcgeachy is offline Senior Member
    Join Date
    Sep 2008
    Posts
    174

    Default

    Given that you list splash.aspx I am guessing you are using a version that is 8 or earlier. Since splash.aspx got redone/renamed to defualt.aspx in version 9. Is that correct?

    Given the information the 1st thing I would do is run a monthly maintenance to see if the speed goes up. Reason being is the customer editors like to list every customer in the database including unregistered customers. If you still have loading issues after doing maintenance with the page customers.aspx try editing the filtering in the customer results to only show registered customers.
  4. 07-10-2013, 03:01 PM #4
    acting_andy is offline Junior Member
    Join Date
    Jul 2010
    Location
    Albany, NY
    Posts
    7

    Default

    Thank you both for the advice, I will report back on what we did and how it worked. And yes we are running 8.0.1.2.