The effect of commissions

Have you ever backtested a profitable strategy and discovered that commissions or spreads made it much less attractive in live trading? How do you account for trading costs?