Buffer Pool- control by time


To control the cyclic buffer pool flushing, we can specify the number of changes and maximum buffer pool size. Can we control the amount of time until the buffer pool should be flushed?

Hi Sean,

What you are asking for is not possible and really does not make sense. If a database was frequently being updated and you specified that a bufferflush only occurs every hour then either the bufferpool becomes full or a flush could take time (like having the flush limit at 99% for example). The only influences on the bufferpool are the size of it and the flush limit which is a percentage of how full the bufferpool becomes until it is flushed. The best thing to do is leave the flush limit at 0. This means Tamino will adjust the write limit to what it thinks best at anyone time.

Hope this helps.

Stuart Fyffe-Collins
Software AG (UK) Ltd.