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