I dont hav e a huge knowledge, but the SD card is more popular, possibly more faster and is used in most devices.
The Cf card uses Flash memory and isnt as popular, and isnt used in as many devices.
In my opinion, the SD card is the better one.
SD = Secure Digital Card
CF = Compact Flash Card
Hope i helped.