Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > SQL SERVER TIMEOUT PROBLEM

Reply
Thread Tools

SQL SERVER TIMEOUT PROBLEM

 
 
Mustafa Yesilkaya
Guest
Posts: n/a
 
      06-30-2004
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?


 
Reply With Quote
 
 
 
 
=?Utf-8?B?QW5pbCBLLiBQYXRoYW5pYQ==?=
Guest
Posts: n/a
 
      06-30-2004
Hi Mustafa

As I came across ur problem there may be some reasons

Application level: 1. Please check the value for connection timeout attribute in connection string
2. Check setting for connection timeout in SQL server settings

Hardware level:
1 . Your processor speed and RAM may be insufficient to process ur request in time it you have large no of records
Move the database on a machine having more memory(RAM) than present system

Hope fully this will help u

regards

Anil Pathania
http://www.velocityreviews.com/forums/(E-Mail Removed)

"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?
>
>
>

 
Reply With Quote
 
 
 
 
Trevor Benedict R
Guest
Posts: n/a
 
      06-30-2004
If you are using a SQL Command object, it should have a Timeout Value.
You can set that.

One more thing you should do is specify the column names in the select
list also try to add the WITH (NOLOCK) clause to aviod waiting for locks
to be released in a table that is being updated. something like

SELECT COLUMN1, COLUMN2 FROM TABLENAME WITH (NOLOCK)

HTH

Trevor Benedict R
MCSD

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
sql timeout from web application problem (works good in sql server dave ASP .Net 2 12-04-2008 02:42 PM
client-side browser timeout OR server-side web server timeout?? (please help) jrefactors@hotmail.com HTML 1 01-04-2005 06:13 AM
client-side browser timeout OR server-side web server timeout?? (please help) jrefactors@hotmail.com Javascript 0 01-04-2005 04:06 AM
client-side browser timeout OR server-side web server timeout?? (please help) jrefactors@hotmail.com Java 0 01-04-2005 04:06 AM
Timeout::timeout and Socket timeout Mark Probert Ruby 1 10-06-2004 09:30 AM



Advertisments