Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    25

    Unanswered: How to determine the status of a query?

    Hi All,

    I have a query that runs for about 10-30min to return results, and was wondering if I add this to a application, how can I determine how long the query has to complete so I can update my progress indicator to the user?

    Thanks
    Matt
    InformixDb (9.52C1)
    Last edited by mlong30; 08-12-11 at 19:09.

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1

    Unhappy

    Hi Matt,


    as far as I know, there is no way to determine how long your query will take.
    Nevertheless, you can have a good idea of the query plan if you include
    "set explain on" before your query. it will write the detailed query plan
    in a file called sqexplain.out in the place you run the query from. This is generally a great way to understand whether your query behaves well and a good indicator to how to enhance it.

    On version 11.70, the explain file is even more detailed and takes execution time of all the steps of your queries.

    But still no prediction on how long it will take

Posting Permissions

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