Is it better to get a smaller bike frame?

Is it better to get a smaller bike frame?