Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Location
    zxczxczxc
    Posts
    52

    Unanswered: When are the modified buffers for fuzzy operations flushed

    Hi,
    During Fuzzy Check point only modified buffers for non fuzzy operations are flushed. my doubt is when are the buffers for fuzzy operations flushed.


    bye
    zxczxczc

  2. #2
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    As far as I know there are several options:

    - LRU cleaning, when you reach LRU_MAX_DIRTY
    - A full checkpoint
    - When the buffer is old and Informix is nearly at the point he would overwrite the logical log on disk that holds the transaction info. So it could be that a fuzzy checkpint flushes 'old' fuzzy operations.

    Idea hbehind it is to do more LRU clenaing and less checkpint cleaning to reduce checkpoint time.

    If you need more info, please let me know.

    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
  •