Spectrogram/ STFT would have a fixed window for all time-frequency analysis, so it would depend on what resolution you are looking for. If you need a better time resolution, use a smaller window, or if you require better frequency resolution, than use a larger window.
Wavelets are meant to overcome this fixed width analysis using scale.

