bcoz cursor works on row-by-row basis taht why it takes long time to execute if there are execess rows in your table...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/