I just received a crystal report where I was told the performance was a little questionable.

So I ran it and let it do its work and it came back 9 minutes later.

So I looked at the command used and there were 6 select statements, though each were fairly simple and simply joined two tables.

Do multiple select statements cause that much of a problem in performance?

do you get the same performance issue if you run it as a query in SQL management studio?

Are the seperate select statements being unioned together?

Upon further inspection, the other select statements weren't from the command, but instead other tables that were manually selected from the list of tables to choose from (I think)

I was looking at the query through "Show SQL query" so I thought the whole thing was a command.

Edited by Keikoku - 24 Mar 2011 at 5:12am