Peformance in database access should be more or less the same, because basically you will have the same queries in both scenarios. But at client side, a designed dataset will produce lots of souce code, not all really needed. I think a manually created database access will produce far less code than the designed one. The advantage of the dataset is that is easier to mantain, add and modify the queries and views.
Best regards, Jaime.