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

    Unanswered: Buffer Allocation

    Hi,

    When i issue a select statement, i find the number of buffers in FLRU does not get reduced though the select statement fetches some number of datapages from the disk. I want to know how does informix allocate buffers for Select Statements. Does it treat the buffers allocated for the Select statements as Free.


    Bye.
    zxczxczc

  2. #2
    Join Date
    Oct 2003
    Posts
    706
    Most software-systems are "lazy." (By design.) If there's no pressure on a buffer pool then why clean it up? If you read the data before and you know it's still good, why read it again? If you need a buffer what difference does it make if you recycle or grow the pool? There's an eternal rule in data-processing: "Speed or Space." Minimzing the size of buffer-pools (or the amount of "free RAM" in a virtual-memory system) is simply not a priority; especially since the memory is virtual and will be paged-out anyway if pressure actually develops on the OS.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  3. #3
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,
    Please read the IBM Informix Dynamic Server Administrator’s Guide page 7-34.

    Gustavo.

Posting Permissions

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