Late-1990s systems supported practically tear-free updates for most practical uses, but AIUI there was not enough memory bandwidth for whole-screen updates to be tear-free, especially at higher resolutions and color depths. This is what Carmack is complaining about here.

Even then, there are better and worse ways of coping with limited video memory bandwidth, and what's "best" depends on the given application.