Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 742
  • Last Modified:

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.
0
qbjgqbjg
Asked:
qbjgqbjg
  • 2
  • 2
2 Solutions
 
peter57rCommented:
The sql command is definitely NOT executed locally.  CR has no ability to do such things.
The command is submitted to the database server which executes it.

There are probably management tools on SQL Server that would enable you to see how each request was executed, but on the face of it , i agree it does sound a bit odd.

0
 
mlmccCommented:
Are you  using the same filtering?

How are you determining that it is slower?

mlmcc
0
 
mlmccCommented:
When you run it each way can you show what the SQL is?
Click DATABASE --> SHOW SQL QUERY

That will show what was passed to the database.

mlmcc
0
 
qbjgqbjgConsultantAuthor Commented:
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.
0
 
qbjgqbjgConsultantAuthor Commented:
Thanks for your comments.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now