Regarding Sql Query

Question

Hi, I have a table with more than 2.5 Lakh record and it is updated daily. I want to fetch all updated record. But there is an error of Timeout Expression. Kindly suggest me, how can i do. Thanks with kind regards Pawan Kumar 8130385975 kingpawan72@gmail.com

Suraj Kumar · Answer

Hello Pawan, As you have not provided the detailed query so it is not possible to suggest where your sql query need to be customized. Please read the below thread it might be helped to you https://stackoverflow.com/questions/8886753/sql-server-still-getting-the-error-of-timeout-expired-the-timeout-period-elaps Thanks Suraj

Shaikh Ateeque · Answer

Hi Pawan, Please implement the proper indexing on the given table and Also select required fields only, dont select * in as select query. May be this will help you. Thanks & Regards, Shaikh Ateeque

Prashant Jayle · Answer

To fetch bulk records you should take care of below points Don't select all columns in table. select minimum which are required Do Proper Indexing on selected columns as per requirements. Check below link for reference - https://stackoverflow.com/questions/21696107/sql-server-indexing-best-practice-sql-server-2008 Check SQL Server query timeout. and set as per your criteria. Also you can provide query. It may help to identify problem

Sanwar Ranwa · Answer

Hello Pawan Kumar Please Check these Links and try to apply on your database it will help you to optimize your database performance https://www.quora.com/What-is-the-best-way-to-handle-large-data-query-from-SQL-Server-when-using-Net-framework https://stackoverflow.com/questions/30058309/the-best-way-to-retrieve-large-amounts-of-data-from-a-sql-server-or-sql-azure https://dba.stackexchange.com/questions/123414/huge-data-and-performance-in-sql-server https://www.freelancer.com/community/articles/23-rules-for-faster-sql-queries

Divyang Desai · Answer

Before throwing anything to you. I would like to ask you few questions, is that necessary to fetch all the records at once? If not then you can fetch it with record limit with background job. Perhaps you can use no SQL for a large dataset

Regarding Sql Query

Answers (5)