blogs on different server

Hi Carlos,

With Kentico you can create multiple sites within one instance. The content is stored in a shared database. There are varies built-in form controls that allow you to select content e.g. blob post from a different site.

How does your setup look like and which Kentico version are you using? Are you using Portal Engine or MVC (Core)?

Cheers, Jeroen

hi,

I am currently working on version v8.1.17.

we have presented performance problems when loading the blogs, we want to send them to a kentico cms on another server and reference it on the main site.

what you think ? is there any possibility of having this structure?

Hi Carlos,

I am sorry to hear that you are experiencing performance issues. Moving them a different server is one way to solve it but there might be other ways to improve performance:

• Have you setup caching properly?
• Have you debugged the underlaying SQL queries that are being executed?
• Have you considered scaling your application?

Cheers, Jeroen

the query that presents me with problems is the following:

SELECT TOP 2 * FROM View_CONTENT_Blog_Joined WHERE ((NodeSiteID = 2) AND (Published = 1)) AND (NodeAliasPath IN (N '/ BLOG / Listado / Dermatologia', N '/ BLOG / Listado', N '/ BLOG')) ORDER BY NodeLevel DESC

I would recommend checking also this article and documentation. There are some general tips and tricks.
I would focus on the web part(s) you are using to display the blogs. In case of the listing web part I would try limit the columns returned from the DB just to those you really need in your transformation (+ some system fields like NodeAlias, NodeAliasPath, etc. needed for certain transformation methods or macros) so the SQL query will return just the data you need and not all 100+ columns.
Then, as mentioned by Jeroen, consider adding some caching to the listing and viewing web part - I guess that the blog posts are not changing that often, so they can be cached for some time.