I have a huge amount of data which is displayed in a
report. The data is viewed every day. Every day the data is
displayed in 30 secs but suddenly today it is giving an
timeout message today. Data has not been changed. The
situation is same as yesterday. What might be the reason???
Please Answer.

Answer Posted / jerry joseph

Number of hits might have increased..

you can try increasing the timeout

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between TRUNCATE and DROP?

627


What happens when converting big values to integers?

568


What is the difference between count and distinct count?

464


Does the order of columns in update statements matter?

474


How to create nested stored procedure?

539






What command is used to create a database in the sql server and how?

600


What is difference between drop truncate and delete?

545


What are “lock” hints?

587


List few advantages of stored procedure.

537


How to receive output values from stored procedures?

479


What is simple indexing method?

571


What happens if you insert a duplicate key for the primary key column in ms sql server?

522


How to create sub reports?

192


What is the difference between sdf and mdf?

677


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1752