Deep Wrote:
Under Ideal conditions avoid using * in select statements and also try to limit teh number of records being sent over the network by using where clause. Try using paging to limit the number of records.
One reason for the time out can be:
The network lines between your web server and database server may be very low. Try firing the same statement on SQL analyzer and check out the difference.
Let me know if this helps.....
"Mustafa Yesilkaya" wrote:
Hi. I have a problem with sql server. I have thousands of record in a
database table. When i want to list all with SELECT * command in asp.net
page, an error message comes : SQL SERVER TIMEOUT.
But when i list with SELECT CITY command there is no error message but the
process is very slow.
Can you help me?