Depends on what you're trying to show off, I suppose. Content is more important than how long it is. You could have a 10 minute demo that sucks and a 2 minute demo that kicks ass. So, if you're making an RPG, just find a good start and stop point that gives a general teaser / summation of what your game is about.