If data size is very big, the single table would perform a little better in the front-end (assuming set analysis would be used in the front-end expression). However, that would trade off in the back-end to take more time in reload and probably server RAM consumption would go high too during load. And this is assuming that, the single table conversion has been done in optimum way.
