The colder the water, the cooler the smoke. It's safe to say that cooler is better to most cannabis consumers. But keep in mind that filling your piece with warm water is still going to cool the smoke. The temperature of the water is always going to be less than the burning bud in your bowl.