Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Location
    sweden
    Posts
    17

    Unanswered: update statistics take long time

    Hi!
    I do have problem with update statistics. This update did take about 35 min and now take 1 hour. I did reorg the database and after that it did take 20 minuts and after a week it start agien to take 1 houer. well the data hase been increesed but it is not so much that give this effect.
    Any body have an idee what kind of problem could be ?

    Linux
    Linux

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,
    Please run update statistics in parallel process.

    Gustavo.

  3. #3
    Join Date
    Nov 2003
    Location
    sweden
    Posts
    17
    Hi,
    What you mean ? how I can do that ? I do have 4 CPU on this maskin and 3 of them is for informix databases.
    Linux

  4. #4
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,
    Arm a file with the sentences of update statistics by each table in all database and then divide into various files ".sql" and execute them with dbaccess in parallel.

    Gustavo.

  5. #5
    Join Date
    Nov 2003
    Location
    sweden
    Posts
    17
    Thanks , now I understand what you mean. well it is a good idee. It should work, but what you think if you there is a diffrens between running update statistics for the whole database and update statistics for just applikations tables ? and what happend to the systables and other Informix tables ? do they need an update statistics ?
    Linux

Posting Permissions

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