Is the type of card a digital camera takes something I should worry about? I'd always assumed CF to be slower than SD but is this the case?

I'm thinking of getting the Canon Ixus 500 which takes CF cards. I really hate having to wait ages between photos while the card gets written to. Also will the type of card affect the lag between me pressing the 'take a photo button' and the photo being taken?