Worst days for the DMV are beginning of the month and Mondays. Last time I was there I got there around 2pm mid week and didn't wait more than 15 minutes before my number was called.
You can do quite a bit online with the DMV which really cuts down on the traffic.
