.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

How select huge Data from sql without take long time?

Posted By: Mohamed Elsokary     Posted Date: March 26, 2014    Points:5   Category :Sql Server
i have 3 tables have thousands of records and make join between them and query return hundred thousands of record that take long time to appear in my application ,how can overcome this problem?

Author: Ashutosh Jha             
Posted Date: March 31, 2014     Points: 20   

Hi you can optimize the query. Also you can use parallel in the query so that its execution time will be less.
please see below link for more detail-

Ashutosh Jha

Author: Deco             
Posted Date: May 13, 2014     Points: 20   

You have to check if you are using table variable to hold the records.
Also you need to check if the joining columns are having indexes built on it.

Author: Akhil Raj       [Moderator]      
Posted Date: May 19, 2014     Points: 20   

In addtion to the data DB level tunding, also think the possibilities of paging in your front end. Instead of showing all the records display some 50 or 100 at a time, if possible

Author: Ram             
Posted Date: August 24, 2015     Points: 20   

Try these steps:

1.Run Execution plan and you can locate which is making the query run more time.
2.Add WITH NOLOCK in all tables.
3.Some times using join also will take time to execute the query,check the joins

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend