Optimize 2 SQL queries to avoid nested select statements

İptal Edildi İlan edilme: 7 yıl önce Teslim sırasında ödenir
İptal Edildi Teslim sırasında ödenir

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# Programlama SQL

Proje NO: #13557796

Proje hakkında

80 teklif Uzak proje Aktif 7 yıl önce

Bu iş için 80 freelancer ortalamada $126 teklif veriyor

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 Daha Fazla

$263 USD in 7 gün içinde
(177 Değerlendirme)
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 gün içinde
(399 Değerlendirme)
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 gün içinde
(55 Değerlendirme)
7.7
WebInfoSolutions

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(147 Değerlendirme)
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 Daha Fazla

$31 USD in 3 gün içinde
(59 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(131 Değerlendirme)
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 gün içinde
(72 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(76 Değerlendirme)
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 Daha Fazla

$168 USD in 3 gün içinde
(53 Değerlendirme)
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 Daha Fazla

$83 USD in 3 gün içinde
(114 Değerlendirme)
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 gün içinde
(94 Değerlendirme)
6.0
gkalish

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

$200 USD in 3 gün içinde
(145 Değerlendirme)
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 Daha Fazla

$167 USD in 2 gün içinde
(59 Değerlendirme)
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 gün içinde
(4 Değerlendirme)
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 Daha Fazla

$177 USD in 3 gün içinde
(15 Değerlendirme)
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 Daha Fazla

$100 USD in 2 gün içinde
(42 Değerlendirme)
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. Daha Fazla

$155 USD in 3 gün içinde
(10 Değerlendirme)
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 gün içinde
(27 Değerlendirme)
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 gün içinde
(8 Değerlendirme)
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 Daha Fazla

$155 USD in 3 gün içinde
(9 Değerlendirme)
4.8