If you're talking about letting the car shift, yes the normal drive mode will be more economical as the sport mode will hold the gears longer under acceleration. If you're using the paddles or the switch on the shifter, it could go either way depending on what time in the RPM band you're shifting.