Increase DB cache limit?

David Paras

• July 20, 2012 17:13

Currently we have abpm.dataMapper.dblookup.cache.limit set to 10,000. If we have tables we are hooked up to with ~5million rows, should we up this number to be greater than 5 million so that the entire DB will be cached? Would this improve performance? What is your recommendation on this?

0

• 

  David Paras

  • July 20, 2012 17:13

  Increasing your cache limit to a greater number, possibly around 1 million records would improve performance. We would recommend trying this value initially to ensure that the system's memory would be able to handle the increased cached size. Then you can increase the limit as you deem necessary.

  0

Please sign in to leave a comment.