Hi,
I am developing a C#.net application which shows a report of a retail store, the database contains some lacks records, i wrote a query which retrives data to display in the report. It is taking more than 5 mins to execute the query in SQL Server. When i run this query in my application it is giving "time out" error, In sql server I am getting the records, where as in my .net application it is giving the error.
Please help me in this matter.
Thanks & Regards,
O. NARENDRA BABU.
|
| Author: Antony s Nasarath 12 Oct 2008 | Member Level: Silver | Rating:  Points: 4 |
Hi,
You can limit number of records return at a time, say 1000 records when you load the page and next 1000 when next button clicked on the page.
or
You can increase connection timeout
or You can use third party datgrid like Componentart to get records incrementay (does first option above).
Regards,
Antony
|
| Author: Meetu Choudhary 12 Oct 2008 | Member Level: Gold | Rating: Points: 3 |
i would suggest you to limit your records while fetching it from database and display them in a grid that might help you
--
Thanks and Regards
Meetu Choudhary
|
| Author: Muralidhar 13 Oct 2008 | Member Level: Bronze | Rating: Points: 4 |
If fetching of data is an asynchronous process; then, increasing the coneection timeout looks good. If fetching of data is a synchronous process, it will definitely have an impact on Naive users.
Rather, fetch limited number of records from the database. Doing so, user need not wait for long time till all the records are fetched, and moreover, the UI looks good.
|