Debugging SLOOOW reports

[Nerdhurd]

Howdy, using crystal 8.5 via ODBC to a progress 9.1d database. My report runs fine unless I narrow the search slightly by adding another condition to the select statement

If company = 101

Then it takes upwards of 5 minutes to run and says ACCESSING DATABASE! normally takes 3 seconds!

I guess is there some way I can diagnois how its getting hung up? The select statement shouldn't be this big of a problem

thanks

 

[rosemaryl]

Dear Nerdhurd,

Please check the following:

Database/Show SQL Query

Is there a where clause?

If not, check this: File/Report Options: Use Index or Server for Speed should be checked. (You can set this globally: File/Options/Database Check the User Index or Sever for Speed and Check Perform Grouping on Server.

Rerun report, is there now a where clause in the sql statement? If not, please post selection criteria and copy the database/show sql query here.

Thanks,
ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[synapsevampire]

Since If company = 101 isn't a valid select statement, you need to fully describe your dilema.

If you intend to limit rows by some field, go into Report->Edit Selection Formula->Record and place something like:

{table.company} = 101

As Ro pointed out, you also want to make sure that this statement is then reflected in the Database->Show SQL Query

The following FAQ should help you understand how CR 8.5 optimizes SQL:

faq767-3825

-k