It depends on many factors like target, focal length, camera, and other things. ALT-AZ mounts are somewhat limited in exposure duration for most targets other than planetary. Star trails can become a real issue after 15-30 seconds. Stacking many short exposures can help, but it's still limited.
I use EQ mounts for virtually everything I do, including wide field Milky Way shots. When I am shooting DSO targets, I tend to use exposures of 2-10 minutes.