OptimizeMePlease

You are probably here because you saw my post on Linkedin.

Welcome!

Steps

Before you run an application, you will need to create a database (I'm using MSSQL) named "OptimizeMePlease"
Go to Program.cs class
"IWillPopulateDate()" is a method which will get a script from the project directory and run in on created DB
Run application in Debug/Release mode
Comment or delete IWillPopulateData() call from Main method
Go to BenchmarkService.cs class
Start coding within GetAuthors_Optimized method

How do I submit my solution?

Send me a Linkedin message with your github username, I will add you and create a branch for you.

OR

Clone the project, create a branch and work on that branch.

OR

If you don't want to bother with github, after you're done with the changes, send me the results on Linkedin.

Rules

Only Entity Framework (Core) is allowed for using
The data obtained in the non-optimized version of the code must also be obtained in the optimized version
If you see potential optimization of something else, you can do it
Entities and DbContext cannot be changed (you got legacy code no matter what it might be bad :) )
The models returned from the method can be changed

What should the method return?

Given that there is a predefined database of data, the method should in any case return the list of data currently returned by the non-optimized method.

How will performance success be measured?

Given that each of us works on a computer with different performance and power, the execution time quotient of the non-optimized and optimized method will be checked for each separately.

Example:

Non-optimized method Execution time: 1.1s = 1100ms Optimized method Execution time: 200ms

Result: 1100ms/200ms = 5.5x faster.

In addition, I will check the performance on my computer for individual results.

GOOD LUCK!