Hello DotNet Reddit Community!

We use .NET C# (4.5.2), EntityFramework (6.2.0), MVC/WebAPI (5.2.3), and Azure SQL hosted on Azure to run our e-commerce platform. Currently we have an API setup to take in search requests from customers, which then returns paginated product data. This API currently works, but we would like to optimize it so we can return the expected results faster. Currently most search queries take anywhere from 2 to 8 seconds to complete. We'd like to get them under 1 second. We've narrowed down the points of slow processing down to filtering the search results by our "product tags", and when we paginate the actual data. Everything else seems to be processing instantly (as expected).

We are looking to hire a .NET expert to take a look at our method (324 lines total) and make suggestions, improvements, etc. This could also include suggestions or improvements to our Azure, SQL, etc. We can do this via Skype, screen-sharing, or we can paste-bin some code. We probably would not want to share our private Git repo for the entire project just yet, but if you feel that is a requirement for you to get this done, we're willing to negotiate on that term.

Successful completion of the project will be when we can run searches for products and get results consistently back in under a second (the faster the better). We are willing to pay hourly, or a flat rate. Totally up to you. There is no particular deadline for this task, but the quicker it gets done the happier we'll be! We'd prefer to pay with credit card or mailed check, but may be able to PayPal transfer or Venmo if necessary.

I hope this is the right place to post this requests! If not, please let us know and we'll take this down and post somewhere else. If you have any questions just let us know and we'll try to answer them promptly.