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

    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?

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

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


    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