Chad

Improve logging performance by checking Trace/Debug log level is enabled

1

### Prerequisites - [x ] I have added steps to test this contribution in the description below If there's an existing issue for this PR then this fixes ### Description...

Fix Nucache rebuilding more type caches than necessary

1

### Prerequisites - [x] I have added steps to test this contribution in the description below If there's an existing issue for this PR then this fixes ### Description Fix...

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

13

Block list very slow to / fails to render labels when using `{{ propertyName | ncNodeName}}` ## Umbraco version I am seeing this issue on Umbraco version: 8.12.2 Reproduction ------------...

Improve SQL query performance by adding missing SQL indexes

8

### Which *exact* Umbraco version are you using? For example: 9.0.1 - don't just write v9 9.4.3 ### Bug summary There are a few missing SQL indexes for queries used...

Avoid logging allocations when debug logging level is not enabled. Checks if the debug log level is enabled before calling log debug methods. This saves on creating the params array,...

Add computed columns for upper(text) and upper(path) on umbracoNode and indexes

1

### Prerequisites - [ ] I have added steps to test this contribution in the description below If there's an existing issue for this PR then this fixes ### Description...

[FEATURE] Transactional Zone Tree Iterator

3

**Is your feature request related to a problem? Please describe.** ITransactionalZoneTree does not have a way to iterate the items. **Describe the solution you'd like** CreateIterator from IZoneTree supported on...

Improve backoffice performance by adding SQL indexes for backoffice queries

9

### Prerequisites - [x] I have added steps to test this contribution in the description below If there's an existing issue for this PR then this fixes ### Description What:...

Adds support for Facet Drill Down and Drill Sideways Adds tests for Facet Drill Down and Drill Sideways See GivenTaxonomyIndexFacetDrillDownSubquery_Returns_ExpectedTotals_Facet test for usage. Add examples to docs ### DrillDown Query...

Adds abstractions and Lucene support for Spatial Indexing, Searching, Filtering and Sorting. Adds tests to cover geo spatial operations. Adds docfx docs for spatial indexing, searching, filtering and sorting. |...