Effective spectral approximations of convection-diffusion equations