Slow Page Loads

Its just slowed down again having run well all morning....

I have checked the SQL profiler and its not down to that, I have one or two long running queries but they run fast and do not have missing indexes like before so there must be something else going on - something else that makes them run slow at times but fast at others - it has been like this - slow one minute and fast the next although I am improving matters. I increased server memory to 3Gb from 2Gb last week to improve matters. I will update this thread when I find it..

I checked and it's not a bandwith problem.

It must be on your server. Best is to find out what is causing the slowness: http://articles.sitepoint.com/article/aspnet-performance-tips

IIS Trace and Profiler are your tools.

Its not in the SQL, there are other issues I think. I'm just trying a site on another server. I'll update this thread when I find them...

ericsolan wrote:

I am having the same issues.  It takes a little over a minute for the first page to load, then all the other pages load pretty fast. I had a look at both of these sites (http://www.setcronjob.com or http://www.keepaliveforever.com) and it says they are only for Linux.  Are you saying they will work for Windows too?

Chad

I think the SQL is ok, certainly the problems I have found have been fixed its something else now, page load speed about 10 seconds after some config changes (memory) on the server... I'll update this thread when I find it..

Just seen these other posts, I've got keep alive on... If only it was as simple as the first access after a few minutes... Its consistently slow, then it goes fast for a few hours, and then its slow again, I mean when I'm continously browsing. When I go into the product details page its using 30% CPU on my 4 processor server, and all the indexes are ok...

So it seems IIS related? I the speed different on a test server?

I've found it! There is nothing wrong with the SQL now that I've put the indexes on. The problem had to lie in another area. I've checked everything I can think of, statistics, index fragmentation, all sorts of memory issues. Couldn't find it, so I went back to basics and ran debug on the code.

The code in Modules/RelatedProducts.ascx.cs turned out to be the culprit.

                var products = ProductManager.GetAllProducts(0,
                    0, 0, null, null, null, this.ProductId, string.Empty, false, int.MaxValue,
                    0, null, NopContext.Current.WorkingLanguage.LanguageId,
                    ProductSortingEnum.Position, out totalRecords);

I changed the code to:

                var products = ProductManager.GetRelatedProductsByProductId1(this.ProductId);

And this finally resolved it.

I think that the stored procedure underlying the first call is very resource intensive and I'm going to  look for other occurances of it in the public site and re-code as necessary.

Did you look at this one: http://www.fuzionagency.com/?tag=/NOP+Commerce

I have looked at this thread but there was a bug in the code and it was only marginly faster.

https://www.nopcommerce.com/boards/t/6830/nop_productloadallpaged-performance.aspx

I think that calling nop_productloadallpaged when not paging is unnecessary.

Yes, this procedure needs improving, but for now I am going to remove this and replace with linq procedures - these are many, many times faster, between 10 and 20 seconds quicker on my system.

By the way, there was a bug in the code in the previous post - the function has to return Product, not RelatedProduct so I have amended the line of code to:

                var products = ProductManager.GetProductsRelatedByProductId1(this.ProductId);

And I have created a new function to do this in ProductManager.cs

       /// <summary>
        /// Return the products themselves not the related products
        /// </summary>
        /// <param name="productId1"></param>
        /// <returns></returns>
        public static List<Product> GetProductsRelatedByProductId1(int productId1)
        {
            bool showHidden = NopContext.Current.IsAdmin;

            var context = ObjectContextHelper.CurrentObjectContext;
            var query = from rp in context.RelatedProducts
                        join p in context.Products on rp.ProductId2 equals p.ProductId
                        where rp.ProductId1 == productId1 &&
                        !p.Deleted &&
                        (showHidden || p.Published)
                        orderby rp.DisplayOrder
                        select p;

            var products = query.ToList();
            return products;
        }

Tested, it appears to work ok.