#REDUCE STARTUP TIME FULL#

Note 740819.1 is quite useful in discussing why you should always try to shutdown a database gracefully, in order to minimize restart times. If you're doing ttDaemonAdmin -stop when there are active connections to the database, you could be forcing the database to be invalidated, and as a consequence much more has to be done when you start the instance / reload the database. You could also look at how you're shutting down either the database or the instance. There may well be other reasons for this, but it's always been part of the architecture and recovery process. The checkpoint also writes out the DB header, which I think has fields updated during the recovery process. Of course, there were a number of different approaches we could take to achieve this, each with its own trade-offs. js files without the ts-node wrapper would greatly decrease the startup time, as we observed in the second flame graph.

#REDUCE STARTUP TIME FULL#

TimesTen performs a checkpoint at the end of recovery to purge the transaction log files it no longer needs, and bring it to full consistency. At least, in theory, having a node process load. Parallel checkpoint reads at startup are unlikely to help and may actually hinder reads from conventional spinning disks. If you're able to locate your checkpoint files on SSD or flash, then it's likely to be faster anyway, and you can then take advantage of parallel checkpoint reads at startup (see Docs and Note1987463.1 for details).

You could investigate whether this is the anticipated read I/O rate for your hardware, or whether it indicates improvements are possible. Your speed is roughly 50GB / 1800 secs, which is around 30MB per second. If you're getting poor read rates (and so taking longer to startup than desired) TimesTen is constrained by this rather than anything that can be tuned in the database. The ttmesg.log will include messages on how many bytes from a checkpoint file have been read in a certain amount of time, so it's easy to calculate what your read I/O rate is.

Reduce startup time