Hello guys,

I have a problem when I try to load my paginated articles I got a timeout error, probably because now there are too many articles in that section, can you kindly try to help me to figure it out what's the best way to optimize my code? you can find it below. thanks

  private int GetRootNodeByLanguage(string language)
    {
        var i = language.Equals("en-US") ? 0 : 1;
        return UmbracoCommon.Content.GetContentByType("feedItemList").ElementAt(i).Id;
    }

public IEnumerable<IContent> GetArticles(string language = null, string page = null)
    {
        if (language == null) language = UmbracoCommon.Language.GetDomainLanguage();

        var nodeId = GetRootNodeByLanguage(language);

        var allArticlesCount = ApplicationContext.Current.Services.ContentService.GetById(nodeId)
                        .Descendants().Count();

        var paging = PagingHelper.GetPages(allArticlesCount, 20, page);

        var selectedArticles = ApplicationContext.Current.Services.ContentService.GetById(nodeId)
                        .Descendants().Skip(paging.Skip).Take(paging.Take).ToList();

        return selectedArticles;
    }

public static IEnumerable

    {
        return uQuery.GetNodesByType(type);
    }

private static Domain GetDomain(int nodeId = -1) { if (nodeId == -1) nodeId = uQuery.GetCurrentNode().Id;

        // get the domains for the node Id
        var domains = library.GetCurrentDomains(nodeId);

        // check that a domain exists
        if (domains != null && domains.Length > 0)
        {
            // return the language id from the first domain
            return domains[0];
        }

        return null;
    }

public static string GetDomainLanguage(int nodeId = -1) { return GetDomain(nodeId).Language.CultureAlias; }

public static Paging GetPages(int itemCount, int itemsPerPage, string page = null) { int currentPage; int.TryParse(HttpContext.Current.Request.QueryString["page"], out currentPage);

        if (page != null) int.TryParse(page, out currentPage);

        if (currentPage < 1) currentPage = 1;

        var pages = new Paging
        {
            ItemsPerPage = itemsPerPage,
            CurrentPage = currentPage,
            PreviousPage = currentPage - 1,
            NextPage = currentPage + 1,
            TotalPages = (int) Math.Ceiling((double) itemCount/itemsPerPage),
            Skip = itemsPerPage*currentPage - itemsPerPage,
            Take = itemsPerPage
        };

        return pages;
    }