Optimize 2 SQL queries to avoid nested select statements

Cancelled Posted 7 years ago Paid on delivery
Cancelled Paid on delivery

We have a website which displays lists of loans. currently we have two pages pages which query the database to get the list of loans, then within the loop that displays all of the loans it queries the database again to get additional information. This is greatly effecting page load time when large quantities of loans are displayed.

We want to optimize these two pages to avoid using nested SELECT queries and improve the page load time. the site is built in asp.NET and MS SQL database.

Can give more info about the project and specific code to those interested in the project.

.NET ASP.NET C# Programming SQL

Project ID: #13557796

About the project

80 proposals Remote project Active 7 years ago

80 freelancers are bidding on average $126 for this job

ambar

Look, I cant say anything I will not check the files. Because I do not think it is correct to suggest something wrong and specially where I will have to work for optimization. To be very honest I am not sure in this mo More

$263 USD in 7 days
(177 Reviews)
9.0
sumon355

Hello, As an expert query writer, i am very much interested to optimize your query. Looking forward to have a positive response from you. Thanks

$70 USD in 2 days
(399 Reviews)
8.2
designysoft

give me 2 days of time and I will resolve the performance issue related with the query you are facing.

$250 USD in 2 days
(55 Reviews)
7.7
WebInfoSolutions

Can I check the code?..............................................................................................................................

$34 USD in 1 day
(147 Reviews)
7.3
shreesols

I am not saying you to award me now. I would prefer if you will first give me the details so that I can check on this. I will fix it and will update you, if you think everything is going fine then you can award me the More

$31 USD in 3 days
(59 Reviews)
7.1
sureshdevi

I can optimize your two web pages sql queries to avoid nested select statements. I will complete this work in a day. Looking for your reply to start this work immediately. I will be available online from 2 am GMT t More

$49 USD in 1 day
(131 Reviews)
6.5
kmpal

Hi, I am an experienced developer with vast experience in .NET, MVC and SQL available for this project. I am full time freelancer available 10 hours daily. Thanks and best regards Khalid

$150 USD in 7 days
(72 Reviews)
6.3
codetod

Hi I am a database expert with 12 years experience in handling MS SQL databases. I do understand that you have to SQL queries, second one being called for each row of the first query. So we will need to combine b More

$60 USD in 1 day
(76 Reviews)
6.4
arityinfoway

Hello Sir, I have gone through your requirements regarding Optimize 2 SQL queries to avoid nested select statements. we brief and understand your idea and preference for job as you are looking for. I have more th More

$168 USD in 3 days
(53 Reviews)
6.5
mail2vimalarora

Hi, I have gone through your project details and would like to take an opportunity to work on it. Being experienced in handling SQL queries and optimizing it greatly and working professionally on queries, I can opti More

$83 USD in 3 days
(114 Reviews)
6.0
netcoder

Hi, I think I can do it:-)! I have a lot of experience in SQL Server development. Best regards:-)

$77 USD in 3 days
(94 Reviews)
6.0
gkalish

Having 13 + years experience in SQL Server programming and willing to start the work immediately .

$200 USD in 3 days
(145 Reviews)
6.5
milansahu2010

6 years+ experience on .Net, C#, AngularJS, WCF, Bootstrap, HTML5, SQL Server, Telerik Controls. I am Milan Sahu. I am willing to do your project. I am interested in a long term relationship with you. Waiting for a More

$167 USD in 2 days
(59 Reviews)
6.3
iramrao

Professional ASP.NET and MS sql developer. I can optimize these queries for you. Looking forward to hear from you. Thanks

$147 USD in 3 days
(4 Reviews)
5.4
lalitatmt

Hello Sir/Madam, I am having around 13 years of experience in mobile & .NET technologies. I am expert in CSS, HTML, asp.net MVC, Web API, asp.net, WPF, AngularJs, TypeScript, ExtJS, YUI, JQuery, Bootstrapper framewo More

$177 USD in 3 days
(15 Reviews)
5.7
jagdishbhatt38

I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utili More

$100 USD in 2 days
(42 Reviews)
5.5
IMExpertEngineer

Hello, I'm expert in Sql server query optimizing and I can easily identify issues in this nested loop query and will fix it and page load will be speedy. I've over 10 years of experience in sql server and in asp. More

$155 USD in 3 days
(10 Reviews)
4.9
shiva1888

Hi I have been in this industry for 5 years and such jobs are my daily practice.I can assure you that if you work with me once, you will always work with me for these kind of projects.

$170 USD in 3 days
(27 Reviews)
4.9
riki888vw

Hi, I have experience with SQL and TSQL. I can do your project. Please send me SQL files to review. Regards, Slavi.

$170 USD in 3 days
(8 Reviews)
4.7
webmynesys

Hello There, I hope you are doing well. I have read your requirement of optimizing pages to improve load time. I have keen interest to help you. I am senior Asp.Net and MS SQL programmer and DBA having 9+ year More

$155 USD in 3 days
(9 Reviews)
4.8