I have a 4.9.1 install of Umbraco connecting to a locally held SQL Server. In this Umbraco instance there are probably about 1000 nodes (Content, Members, Media, etc) and I'm having an issue when I try to create/amend content nodes.
Basically when I view the content tree, it populates more or less instantly (the same for when I expand any content siblings) but if I actually select a content page to add/amend content it takes between 20-50 seconds to display the content and then about the same again to save the content.
A lot of the forums that I've read are talking about adding Indexes to various tables in the SQL backend but I'm no DBA so I'm a little nervous about doing this. Does anybody have any suggestions on what I could try to speed the content publishing up?
Craig,
You dont seem to have that much content. I suspect you have a data type that is causing load issues. Does this happen with all your nodes? If may be that only one specific type of node causes the issue if so then look at datatypes on that node type else if its happening with every node then look at your document type inheritance and see if they have a data type that looks a bit suspect. For example you may be using some kind of xpath picker datatype that is doing a crazy select query?
Thanks for replying. I do have an ultimate Picker on each the template but I've specified the parent node id of this and it only has 6 children. All of the other document types/inheritence look ok to me.
Speed of amending/creating content
Hi all,
I have a 4.9.1 install of Umbraco connecting to a locally held SQL Server. In this Umbraco instance there are probably about 1000 nodes (Content, Members, Media, etc) and I'm having an issue when I try to create/amend content nodes.
Basically when I view the content tree, it populates more or less instantly (the same for when I expand any content siblings) but if I actually select a content page to add/amend content it takes between 20-50 seconds to display the content and then about the same again to save the content.
A lot of the forums that I've read are talking about adding Indexes to various tables in the SQL backend but I'm no DBA so I'm a little nervous about doing this. Does anybody have any suggestions on what I could try to speed the content publishing up?
Any help would be massively appreciated.
Craig
Craig, You dont seem to have that much content. I suspect you have a data type that is causing load issues. Does this happen with all your nodes? If may be that only one specific type of node causes the issue if so then look at datatypes on that node type else if its happening with every node then look at your document type inheritance and see if they have a data type that looks a bit suspect. For example you may be using some kind of xpath picker datatype that is doing a crazy select query?
Regards
Ismail
Hi Ismail.
Thanks for replying. I do have an ultimate Picker on each the template but I've specified the parent node id of this and it only has 6 children. All of the other document types/inheritence look ok to me.
Thanks,
Craig,
Is the ultimate picker on all doc types? Can you identify any nodes based on a particular doc type that do not run slow?
Regards
Ismail
Hi again Ismail,
The ultimate picker is on all nodes (I use it select a select a CSS class)
Thanks,
Craig
is working on a reply...