Raymond Raymond wrote:
I am doing some tests on Derby checkpoint. You know, with the same number of cache pages, if the percentage of dirty pages is higher, deby will dump more pages during checkpoint. I want to see what impact it will give to Derby's performance when I tune the percentage of dirty pages higher. As I observed, the default percentage is like 20%. But I don't know how to set it as the number I want.
My guess is that the "default percentage" you are seeing is the result of the workload you are using. I don't believe Derby has any concept of an optimal or default dirty page percentage.
Dan.
