The number of messages (afaik) isn't limited in any way.. the messaging app is actually done pretty nicely - it only displays last few conversations, and if you scroll upwards, it loads older and older messages continuously..

Because of that, and because the messages are stored in a SQLite database (which shouldn't have performance problems even with millions of messages - if you are only interested in last few ones), you most probably don't have to worry about this...