A higher DPI is better. If you want to move your mouse pointer to an exact pixel position, a higher DPI mouse will be more accurate, whereas with a lower DPI mouse, you will find yourself giving it little nudges just to get to an exact spot.
Just for casual computing, DPI doesn't really matter.