Join Types---SLOW

[rhoneyfi]

Hello,
I am creating a Crystal Report (9.0) and connecting to two sql databases. There are about 30,000 records in the first DB and 1,000 in the second. I have made this nice fancy crosstab report, but it takes like 2 minutes to run. Is there anyway to make it run faster?
Basically, the have a left outjoin for the first database (Salesperson) to the second database (Sales). The crosstab is arranged with the Salesman name in the first row, and then the product type in the second row. The month is the column. I am pretty new with joining databases togther, but I know it shouldn't take this long to load. My other databases that are based off one table take only 5 seconds to run (30,000 records)

 

[synapsevampire]

Do you mean 2 different databases, or 2 different tables?

In case you're unaware, those are very different things, a database contains tables, a table contains data.

Joining different databases is generally slow in Crystal as all join processing is done within Crystal.

Joining tables is passed as SQL to the database, with the gating factors being whether your criteria (report->record selection formula) is being passed to the database as a where clause (Database->Show SQL Query).

If you post specifics someone may help to speed things up:

Database type )SQL database can mean many types)
connectivity used (ODBC< native, OLE-DB)
record selection formula
SQL being passed

I have a FAQ on this topic:

faq767-3825

Hope this helps.

-k