With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
90245, United States
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I have an MS SQL Server query that takes < 5 seconds to execute using indexing, but approximately 20 seconds to execute on a .NET web page hosted on GoDaddy. The query contains approx 13 common table expressions, each of which perform a calculation on a unique join or 'where' condition. There are approx 8 tables joined together at different parts of the query, one of which has 800,000 records.
Objective is to execute the query & return the output to listboxes on the webpage in < 3 seconds. The web page is already fully programmed to populate the query output... objective of this project is simply to reduce page response time to < 3 seconds.
Based on this information, are you confident you can achieve the results? How would you proceed, in general terms?
Job award would be dependent on signing an IP / NDA agreement.
Sign in or Register to see more