Home > Archive > Visual Basic Crystal Reports > April 2005 > Loading Fields Table Crystal Report vs Reporting Services
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Loading Fields Table Crystal Report vs Reporting Services
|
|
| Resant 2005-04-29, 4:03 am |
| I have 2 tables contain fields as below :
- A : f1, f2, f3, f4, f5
- B : f1, f2, f3, f4, f5, f6, f7, f8, f9, f10
I want to create report, Which table that will give best performance?
This question appear because I want to compare Crsytal Report and
Reporting Services. At Crystal, no matter of your query all fields of
table will be load and appear at Field Explorer, meanwhile Reporting
Services only load fields that's included in your query.
| |
| Brian Bischof 2005-04-29, 4:03 am |
| Crystal only loads all fields into the Explorer so that you can choose any
field to print from. This is during design time only. When it queries the
database it only selects the fields that appear on the report. If you're
looking for performance issues, you need to research more deeply than just
fields selected. The database libraries are much more complex in how they
query and process data and there is no simple answer for what you are
asking. You have to do testing on your own reports if you want to see how
your application will perform.
I have a paper that compares SSRS to CR on my website. This might prove
helpful to you as well.
www.CrystalReportsBook.com
HTH,
Brian Bischof
"Resant" <resant_v@yahoo.com> wrote in message
news:1114750213.769011.218160@l41g2000cwc.googlegroups.com...
> I have 2 tables contain fields as below :
> - A : f1, f2, f3, f4, f5
> - B : f1, f2, f3, f4, f5, f6, f7, f8, f9, f10
>
> I want to create report, Which table that will give best performance?
> This question appear because I want to compare Crsytal Report and
> Reporting Services. At Crystal, no matter of your query all fields of
> table will be load and appear at Field Explorer, meanwhile Reporting
> Services only load fields that's included in your query.
>
| |
| Resant 2005-04-29, 4:03 am |
| I agree with you about 'performance not only depend on total fields',
but currently I would like to denormalize my database for report
requirement, from splitted tables into one giant table that have many
fields. So in this case, I just want to look from total fields
perception.
>From your respond, I summed that total amount fields of table doesn't
affect Crystal Report performance, means that Table A or Table B with
the same query for report will give same performance. Is it right?
By the way, your white paper is very usefull, but I think it will more
easy to read if the comparation is summarized in table form.
Thanks a lot
|
|
|
|
|