Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


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?

link comment (0)
asked 3 years ago
sqlcopter
284
14 Answers
0
See the configuration parameter data_buffer_sizeThis 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.
link comment (0)
answered 3 years ago
datageek
6




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: