Why crystal report takes time to display data, when unlinked table exist?

[Former Member]

Hello, All,

When in Database Expert window any unlinked table exist, it takes time to display data in report viewer.

Please refer attached file to see tables in Database Expert window.

I have created one report which shows data from access database tables.

I have four tables among them 3 are linked with each other, but 4th  table isn't linked with any of other three tables.

4th table have only one row.

To view report in Crystal Report Viewer it takes around 44 to 45 seconds to show 8000 records,

But if i link 4th table, It doesn't take that much time to show data.

Can any one help me to findout reason for this behaviour?

Regards,

Umesh

[abhilash_kumar]

Hi Umesh,

It takes time because CR still needs to do a Cartesian product with every row from the result set with this one row from the unlinked table.

When you Join tables, the joins are processed by the database server.

-Abhilash