crystal reports sql command vs view
Can anyone tell me why a crystal report using a sql command runs much slower than a crystal using a view (same code as the sql command)? Could it be that the sql command is executed locally and the view is on the server? Crystal Reports XI.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am using no additional filtering. Only what is in the sql. I know that it is slower, because I press the button, then wait awhile with the sql command, but with the view it comes back fairly quickly. I have looked at the sql using show sql, it is exactly what is in the sql command.
ASKER
Thanks for your comments.
How are you determining that it is slower?
mlmcc