Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    7

    Unanswered: Informix dbase: ORDER ENTRY posting slow...

    I have a 4gl accounting program with informix dbase. This last few days, the Order Posting had slowed down tremendously... say 6 hours for 1500 elemest. It used to take no more than an hour to post these or even more element.

    I have checked the index and tables for errors and found two tables that had some corrupted indexes. I have rebuild these tables and are working fine now. The posting didn't change at all, it's still slower than a dying turtle

    Any help or suggestion(s)? Please....


    Thank you.
    Jojo

  2. #2
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    Hi,

    Did you rebuild statistics ??

    Greetz,

    Rob Prop

Posting Permissions

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