The data that resides on the remote partition (in this example, the on-premises partition) will have noticeable latency issues. Remember, performance is determined by the slowest component.