Forum Post: RE: Buffer the whole database

  • Thread starter Thread starter Thomas Mercer-Hursh
  • Start date Start date
Status
Not open for further replies.
T

Thomas Mercer-Hursh

Guest
Note that if you have the database reasonably tuned now, you are probably fulfilling 98% of your requests from the -B buffer pool anyway, so any improvement of getting the rest of the database into the buffer is likely to be small. If you don't have it reasonably tuned, then you can make dramatic improvements without putting the whole DB in there. And, of course, to get the whole thing in -B means having to read every record, which means start up impact.

Continue reading...
 
Status
Not open for further replies.
Back
Top