Query Timeout on First Execution

Results 1 to 2 of 2

Thread: Query Timeout on First Execution

  1. #1
    Join Date
    Dec 1969

    Default Query Timeout on First Execution

    I have a query(s) that when I come in in the morning will timeout. I get a script timeout error. I have looked everywhere for this but all they say is that I have an infinite loop... Which I do not. The funny thing is that if I run the query again it comes back fine. It will work the rest of the day fine. It is just the first time coming in in the morning. I am not the only one that has the problem. Also it happens to more that just one query. Any suggestions would be appreciated. I am thinking it has something to do with the driver (Microsoft Oracle for ODBC) and it having problems initializing, but I am not sure. Thanks in advance.

  2. #2
    Join Date
    Dec 1969

    Default RE: Query Timeout on First Execution

    Sounds more like a database performance issue - a question for your DB Admin. Likely as not, the query is not in memory first thing in morning, the Admin having run a cleanup the previous night. First time you ask for the query, Oracle must load it in memory. From then on its in parsed form in memory and can be used.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts