With that select statement, you're telling the server to give you everything and it's returning in 30 seconds. I don't know about anyone else, but if my 50 column table returned 3mil+ rows in 30 seconds I'd be happy.
There is a way to display the information faster. Get bigger faster hardware or you could just select the columns and data that you're interested in.
--------------------
Colt 45 - the original point and click interface