High-order harmonic generation (HHG) provides scalable sources of coherent extreme ultraviolet radiation with pulse duration down to the attosecond time scale. Efficient HHG requires the constructive interplay between microscopic and macroscopic effects in the generation volume, which can be achieved over a large range of experimental parameters from the driving field properties to those of the generating medium. Here, we present a systematic study of the harmonic yield as a function of gas pressure and medium length. Two regimes for optimum yield are identified, supporting the predictions of a recently proposed analytical model. Our observations are independent on the focusing geometry and, to a large extent, on the pulse duration and laser intensity, providing a versatile approach to HHG optimization.