Good morning,

we have the RichBlog plugin installed on two of our websites:
www.ledpoint.it
– version 4.5.231.35022
www.naturnext.eu
– version 4.7.40.46

The loading of blog pages is very slow: if the page is not yet cached, the site responds in 40–120 seconds.

By checking the database, we see that the following query is executed hundreds of thousands of times:

SELECT [t1].[Id], [t1].[LanguageId], [t1].[IncludeInSitemap], [t1].[Title], [t1].[Body], [t1].[BodyOverview], [t1].[AllowComments], [t1].[Tags], [t1].[StartDateUtc], [t1].[EndDateUtc], [t1].[MetaKeywords], [t1].[MetaDescription], [t1].[MetaTitle], [t1].[LimitedToStores], [t1].[CreatedOnUtc]
FROM [BlogPost] [t1]

This query takes on average more than 2 seconds to return, with peaks of over 200 seconds.
In practice, it performs a full table scan on the BlogPost table.

The BlogPost table contains the following number of records:

www.ledpoint.it
– 738 records
www.naturnext.eu
– 1968 records

The RichBlog plugin has the following settings:

Number of Blog Posts to show (home page): 6
Number of characters in blog post preview – Home Page: 200
Number of characters in blog post preview – Blog list page: 300
Search Settings \ Number Of Items Per Page: 10

It appears that every time a blog page is accessed, the entire table is read without filtering its contents.
Access to blog pages is very slow and the sites are being significantly slowed down.

How can we resolve this issue?

Thank you.
Kind regards.