Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
How select huge Data from sql without take long time?
March 26, 2014
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?
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-
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.
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
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
To post reply
Related Questions Related Questions
getting Error for accessing Data from MS Access using Select Query
How to Add USA Time and Date in Data Base?
How can we select a particular row in the listview control
User can not select TEXT for copy paste from my .aspx page...
how we retrieve data on tab pressing Win App
how to display photo of members in gridview at run time?
xml data into Sql data ursent please
bind xml file data into datatable
Error at reading xml data in C#.NET
how its display the data gridview in vb.net?
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
Passing using parameter in store procedure get the top3 record from the table
how to find the output in sqlserver
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend