Oninit cdi / Archive
Talk to an expert →

pinning tables in cache?

Posted in 2008

Topics: General Discussion

DON POPE — — source: IIUG Forums & Mailing Lists

Hello, In IDS 10, is there a way to pin (or at least pre-load) an object in the buffer cache? Thanks, Don

↪ replying to DON POPE
Art S. Kagel (Oninit) — — source: IIUG Forums & Mailing Lists

DON POPE wrote: > Hello, > > In IDS 10, is there a way to pin (or at least pre-load) an object in the > buffer cache? > No. A command to do that was tried in 7.30/9.21 and it was a dismal failure. The impact on server performance overall was so bad that it outweighed any benefit for access to a small number of tables. The only way to pre-load the table contents into cache would be to perform a table scan early each day. The only way to insure that the data remains in that cache for that table would be to put the table into a dbspace with a different page size from all other dbspaces so it would have a private cache. If the engine guys ever listen to me an implement multiple buffer pools for the same pagesize, that will be much easier to do. Art > Thanks, > Don > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!! > > >

↪ replying to DON POPE
Walter Lowich — — source: IIUG Forums & Mailing Lists

You can read the table into memory in its entirety after bouncing tre system. If you have enough memory, and the table is used regularly, then the table should remain in memory. DON POPE <don_pope@carmax.com> wrote: Hello, In IDS 10, is there a way to pin (or at least pre-load) an object in the buffer cache? Thanks, Don ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! --------------------------------- You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.

Glossary