---
# System prepended metadata

title: '**EF Core Query Optimizations**'

---

# **EF Core Query Optimizations**
* .AsNoTracking() => use this when you do not need a context reference, like returning an object in an api for example

* .AsSplitQuery() => automatically spilts the query for you, no need to do it manually anymore (we will enable this globally via startup.cs)

## **API Test Results**
All testcalls were done using Postman on a locally build SmartUs DEV. The internet connection speed should have been around 50k and the file size was 6.8mb.

### **Old Code**
Call 1: 9.2s
Call 2: 3.2s

### **Old Code with NoTrack and Split**
Call 1: 5.2s
Call 2: 2.8s

### **New Code**
Call 1: 2.2s
Call 2: 1.4s

### **New Code with NoTrack and Split**
Call 1: 1.8s
Call 2: 1.7s

These times should become even faster calling a server hosted system!