It's best to poke holes into a slightly warm cake. If it's too hot, the cake could just suck up the liquid and get soggy. Too cool and the top may crumble when you poke the holes in it.