Developer forum

Forum » CMS - Standard features » Items in items and preformance

Items in items and preformance

Kenneth Radoor
Reply

This is mainly a headup for the dev-team, for an issue that you might want to look into.

Having a page that is build with paragraph-items for the most part, and thise items have one or more fields that is composite itemtypes.

Looking at the dbstat I can se that out of 581 calls to the database 212 of the requests is at scalar query that start like this: "SELECT ParagraphHeader From [Paragraph] WHERE [ParagraphItemType]........", and the specific qyery is repeated several times, "SELECT ParagraphHeader From [Paragraph] WHERE [ParagraphItemType] = 'My_ItemType' AND [ParagraphItemId] = '530'" 

To me it looks like an overkill to request data that many time, especially as it is the paragraphheader for something that do not and never will excist.

To make it really bad, try and create an Item that contains an itemlist, where the items in the list have a field with a composite item. Then you get a load on the DB that scales with factor N

 /Kenneth

 


Replies

 
Rene Poulsen
Reply

Hi Kenneth,

I've experienced something similar. I've also noticed that there can be a very big difference if you use GetValue vs. GetSting.

We have a solution where we have a lot of items with other items inside. We used GetValue a lot of places when looping through the items inside 1 item (can't remember where - but I can look into it if the DW developers need to know?!). This caused the page to have a load time of almost 1 minute (it had a whole lot of database calls - over 2.000). When we changed it to GetString there was no problem at all - the page loaded in no time again.

 
Nicolai Høeg Pedersen
Reply

Hi Rene & Kenneth

We are on this. Will get back to you.

BR Nicolai

 
Kristian Kirkholt
Reply

Hi Rene and Kenneth

The problem TFS#17728 Item performance with item lists

Has now been resolved in Dynamicweb version 8.8.0.0

You are able to find this build in the download section:

http://developer.dynamicweb-cms.com/downloads/dynamicweb-8.aspx

Please contact Dynamicweb Support if you need any additional help regarding this.

Kind Regards
Dynamicweb Support
Kristian Kirkholt

 

You must be logged in to post in the forum