You ask how many turns does a game last. But how long does a turn last? Well into a game on gigantic map, you will have many planets and ships to manage. So as the map size increases not only does the game last more turns but the average turn length also increases!
