The cartridge versus CD tradeoff was real. Square estimated Final Fantasy VII would have needed around thirty 64DD discs on Nintendo hardware, while it shipped on three CD-ROMs for the PlayStation. That storage gap is a big part of why Square moved the game to Sony.
