There is always going to be a trade off in performance whether slight or huge and it does largley depend on the device being used and the connection (speed, lan vs internet). How would you connect your tablet via ethernet? USB?
At anyrate rarely used it myself, but i've seen people swear by Splashtop when it comes to doing anything media intensive.