176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Reduce web page response time for SQL query
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Wed, Aug 15, 2012
  • Time Left: Closed
  • Location: 90245, United States
  • 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.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

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

Job ID: 32746124
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India  |  
12+ years of experience includes in-depth exposure to asp.net, c#, JavaScript, jQuery, angularJS, Web Services, Restful API, Signal R 2, Entity...
5
  |  
 5.0   |  Private   |  4 Jobs
Bid ID: 32871030  |  Submitted: Aug 20, 2012 13:04 ET 
Proposal SEALED

 United States  |  
Over 10 years of experience in design, Development and Implementation of software development life cycle Mission Critical Projects using Microsoft...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32854679  |  Submitted: Aug 19, 2012 23:07 ET 
Proposal SEALED

Luca Spricigo      
Luca Spricigo's identity has been verified.  Learn More
 Italy  |  
I am 36 years old, I am a freelancer with a strong sense of responsibility for the assigned tasks. I am very proficient in most Microsoft programs...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32833482  |  Submitted: Aug 18, 2012 11:10 ET 
Proposal SEALED

 India  |  
Hibiscus Technolab is founded by a group of I.T Professionals from India focusing on Desktop Development,web application development, web 2.0...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32790329  |  Submitted: Aug 16, 2012 14:22 ET 
Proposal SEALED

 United States  |  
- Expertise in SQL Server and MySQL database design and development. - Highly specialized skills in all data and database related issues. - We can...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 32782391  |  Submitted: Aug 16, 2012 08:56 ET 
Proposal SEALED

 India  |  
INVITED
I have over 8 years of experience managing SQL Server databases and over 10 years of IT experience. I am a Microsoft Certified Technical Specialist...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 32778176  |  Submitted: Aug 16, 2012 05:29 ET 
Proposal SEALED

 United States  |  
Winner
I have been fortunate enough to work in the field that I enjoy most and have gained 12 years of experience as a go-to IT professional. I have...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32772962  |  Submitted: Aug 16, 2012 01:08 ET 
Delivery
Within 1 week
$328.77

 New Zealand  |  
Vision: Over 20 years experience in IT, 15 of them in software development. I would be very happy to show you my skills and I am confident you...
6
  |  
 5.0   |  Private   |  1 Jobs   |  6 verified credential(s)
Bid ID: 32753236  |  Submitted: Aug 15, 2012 08:24 ET 
Proposal SEALED

 United States  |  
Mirallen Systems, Inc. provides a full range of skills needed to direct and deliver a successful solution. We believe on quality work rather than...
5
  |  
 5.0   |  Private   |  2 Jobs   |  1 verified credential(s)
Bid ID: 32752642  |  Submitted: Aug 15, 2012 07:53 ET 
Proposal SEALED

 India  |  
i am sandeep sharma. I have six year exp of developement . i am working in pingaksho Technologies as group lead. we have expert person in c#.net,...
Skills: Java, zoomla, Seo
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32751809  |  Submitted: Aug 15, 2012 07:04 ET 
Proposal SEALED

 India  |  
More than two years of experience in IT industry, have specialized in various technologies and understood the current business strategy. Having a...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32751091  |  Submitted: Aug 15, 2012 06:21 ET 
Proposal SEALED

Oleg S.      
Oleg S.'s identity has been verified.  Learn More
 Ukraine  |  
17+ years experience - able to develop almost any system from the scratch Software Development: - Internet web-sites -- Membership based -- Social...
4
  |  
 4.5   |  Private   |  4 Jobs
Bid ID: 32751047  |  Submitted: Aug 15, 2012 06:18 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »