From what I can find, it has a maximum sustainable speed of 9.6, but it can only sustain that for twelve hours, and we also don't know how fast that is, so let's round it down to warp nine. Which Enterprise? ( (NCC-1701-D)) was the one Picard served on. This drive has one drawback and that is, that it is very unstable and needs very precise calculations to not result in Atlantis being vaporized. This is basically a drive operating on the same technology as the Stargates and capable of traversing large distances in the range of seconds (they traveled from the edge of the Milky Way to Earth in some seconds and we know Stargate travel between galaxies also doesn't take more than a few seconds). The City Ship Atlantis has, in addition to it's Stardrive (sublight and Hyperdrive) an additional, experimental drive called the Wormhole Drive. The BC-304 class ships (With ZPM): Around 3.3 daysДЄtlantis (using the Stardrive): Similar speed to Asgard VesselsД«ut there is one that tops all of these (although it is a bit of a cheat).

The BC-304 class ships (Without ZPM): Around 15 days An Asgard (More advanced species) Vessel could make a trip of around 4 million ly km in a few hours. There are also ships in Stargate that are even faster. Equipped with a ZPM (basically the best and most powerful powersupply in the series) they could make the trip in 4 days. Later ships (with better powersources) made it in 18 days. Their first ship made the trip in a few months.

They make many trips between the Milky Way and the Pegasus Galaxy (which is 3 million ly km away). Their speed increases with the available power. Well in Stargate the Earth use Asgard Hyperdrives in their Battle Cruisers.

Stardrive 2 fastest ship