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!