time out expired error

• SREENIVASARAO-314380

  Valued Member

  Points: 64

  More actions

  July 6, 2006 at 3:00 am

  #169459

  hi

  I have table with 10 columns,that table having 10 lack record,

  from appication one query running that is picking up the data like this

  SELECT FROM TABLE1 where NAME AND TEXTID

  some time this query giving error like "time out expired error" any how it is very slow how can solve this problem

  regards

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  July 6, 2006 at 4:29 am

  #647704

  How many rows do you expect to be returned?

  Is there proper indexes in place to support your query? (name and/or textid per your example)

  How slow is 'very slow'?

  Is it always the same or just sometimes?

  How long can it run before you encounter the timeout issue?

  I forget stuff.. how much was a 'lack' again?

  /Kenneth