Performance of unlinked table

[crystaldev1]

Hello. I'm using CR 9 and SQL Server 2005. I have a report that uses multiple tables but only one table is not linked. If the table is linked, the report would generate fairly quickly. If there is any table not linked to anything, the report would take a very long time. I would like to understand why the report is taking so long with an unlinked table. I guess an unlinked table would have to loop through every records. Please explain. Thanks.

 

[Turkbear]

Hi,
Why does the report have an unlinked table - if unlinked, how can it relate to the others?






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[crystaldev1]

For example, if we are running a report about different cities in a county, we could have one unlinked table that stores information about a county. But the county and the city cannot be linked. Just would like to know how this would affect the performance vs linked. Thanks.

 

[Turkbear]

Hi,
If the counties and cities cannot be linked, why have them both in the report ( I am just a little confused as to the why)?

as to performance, if not linked then, depending on where any fields from the unlinked report are included in the report, it could result in the entire county table being read for each record returned from the other linked tables.

( I would use a subreport for the unlinked data since it is not related to the linked tables)





To Paraphrase:"The Help you get is proportional to the Help you give.."