Chad comments

Results 45 comments of


                                            Chad

[FEATURE] Transactional Zone Tree Iterator

Thanks @koculu. I'll give this a go.

NuCache Out of Range Exception

Content likely exceeded block size, causing corruption.

NuCache Out of Range Exception

Likely the redeploy worked because it deletes the nucache.content.db file from disk. When there is no file on disk, the sqldb is read into memory and stored on disk at...

v10: Add HMAC image processing protection

For existing known "safe" crop settings, is there a way to handle this? I.e. new crops use hmac, and then an allow list for known old crop parameters for existing...

Improve SQL query performance by adding missing SQL indexes

More missing indexes: ``` CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsContentType_V2] ON [dbo].[cmsContentType] ( [nodeId] ASC ) INCLUDE([alias],[icon],[thumbnail],[description],[isContainer],[allowAtRoot],[variations],[isElement]) ``` ``` CREATE NONCLUSTERED INDEX [IX_cmsTagRelationship_tagId_nodeId] ON [dbo].[cmsTagRelationship] ( [tagId] ASC, [nodeId] ASC )...

Improve SQL query performance by adding missing SQL indexes

The CMS would benefit from further indexes by migrating all ntext columns to be nvarchar(max) as ntext columns cannot be part of an index.

Improve SQL query performance by adding missing SQL indexes

Removed from the list. The rest are correct.

Improve SQL query performance by adding missing SQL indexes

nvarchar(max)

Issue-12704: added new necessary indexes.

Looks good to me.

Block list very slow to / fails to render labels when using {{ propertyName | ncNodeName}}

@nul800sebastiaan I do have a large amount of content, however the multinodetreepicker loads multiple items quickly. I think the blocklist is loading one item per request.