I've been told that it takes about 200 clock cycles to read from memorym, and somewhere around 1,000,000 clock cycles to read from HDD.
Does anybody know what the comparable number of clock cycles would be to read from SSD?
Those are arbitrary numbers that professors in college state to show how heavy IO code might not be worth wasting time optimizing as it's dependent on the drive speed anyway. Compare the transfer speed of a SSD and a regular Hard Drive. Divide your clock cycle figure that you have by the amount of times the SSD is faster than the Hard Drive. There you go, that's your new "clock cycle" amount. It's still large.
It has more to do with the interface. For instance SSD over SATA, and SSD over PCI-E is a huge difference.