Solved

SQL reports running very slow

Posted on 2011-03-18
3
288 Views
Last Modified: 2012-05-11
I have created two reports one in crystal and one in SQL reports the crystal reports run very fast and the SQL report takes a few min to run, is there a way to speed up the sql reports
0
Comment
Question by:IT_Techno
3 Comments
 
LVL 4

Accepted Solution

by:
Accpac_Attack earned 500 total points
ID: 35165193
In Crystal, click on Database / Show SQL and compare with the SQL from the report.  Typical causes are filters on non-indexed fields or filters on calculated fileds.

Good luck!
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35165387
ARe the reports using the same datasource?

Are the reports showing similar information?

How are you connecting to the database?

Are these on the same machine?

mlmcc
0
 

Author Comment

by:IT_Techno
ID: 35340381
Will confirm and advise
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now