Regarding Sql Query

pawan kumar

8y929Learn iOS Programming

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

[email protected]

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suraj Kumar8y ago
Accepted 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 Ateeque8y ago
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 Jayle8y ago
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 Ranwa8y ago
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 Desai8y ago
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