1
(click on this box to dismiss)
Does Cubrid keep all the pages of a (heavily used) index in memory?
Suppose I heavily use a certain index, and there is enough RAM available on my machine. When scanning for the first time each page is read into memory. After that, are they discarded, or kept? Is there a configuration parameter for this?
![[Level:5]](http://www.cubrid.org/modules/point/icons/default/5.gif "Rank: 5/30, reputation score 284 (84% completed for the next level)"){kind=icon}
sqlcopter
1
Answer
0
See the configuration parameter data_buffer_size. This parameter configures the amount of memory CUBRID is allowed to use for caching pages. If there is enough room to cache all the pages then CUBRID will keep them cached.
![[Level:1]](http://www.cubrid.org/modules/point/icons/default/1.gif "Rank: 1/30, reputation score 6 (0% completed for the next level)"){kind=icon}
datageekasked 2 years ago
viewed 718 times