Performance of RS email delivery VS .NET code email with SMTP

Hi,
I have 2 options of implementing sending data drivent email to customers,
one is coding .NET with SMTP, the other is using RS data driven subscription
with email delivery.
My question is, comparing to .NET code by building email body using
StringBuilder, how is the performance of RS, by making HTML format of email
from Report Definition Languge, XML, I know it's compiled, but XML processing
is alwasy slow, as I understand. Thanks.
TonyWhat sort of volume are you talking about? Two things are happening:
rendering and sending the email. Rendering of the report will be what takes
the longest and will be the same regardless of whether you send it via your
app or use Reporting Services to email it. So, if you plan on emailing the
reports, my guess is the act of sending the email will not make much if any
difference as a percentage of the total time.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tony" <Tony@.discussions.microsoft.com> wrote in message
news:3C91238E-5618-4C23-9C1C-7C8BA7199AC1@.microsoft.com...
> Hi,
> I have 2 options of implementing sending data drivent email to customers,
> one is coding .NET with SMTP, the other is using RS data driven
> subscription
> with email delivery.
> My question is, comparing to .NET code by building email body using
> StringBuilder, how is the performance of RS, by making HTML format of
> email
> from Report Definition Languge, XML, I know it's compiled, but XML
> processing
> is alwasy slow, as I understand. Thanks.
> Tony|||Hi Bruce,
Thanks for your response. My question is rendering reporting from Report
Definition Languge comparing to building email body with .NET application. My
guess is XML processing time, hopfully not DOM, but XML stream, comparing to
stringbuilder inside .NET code. In your response, did you mean sending email
or rending will be the same regardless of 2 options? Sorry about can not
understand the sentence clearly.
Regards,
Tony
"Bruce L-C [MVP]" wrote:
> What sort of volume are you talking about? Two things are happening:
> rendering and sending the email. Rendering of the report will be what takes
> the longest and will be the same regardless of whether you send it via your
> app or use Reporting Services to email it. So, if you plan on emailing the
> reports, my guess is the act of sending the email will not make much if any
> difference as a percentage of the total time.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Tony" <Tony@.discussions.microsoft.com> wrote in message
> news:3C91238E-5618-4C23-9C1C-7C8BA7199AC1@.microsoft.com...
> > Hi,
> > I have 2 options of implementing sending data drivent email to customers,
> > one is coding .NET with SMTP, the other is using RS data driven
> > subscription
> > with email delivery.
> > My question is, comparing to .NET code by building email body using
> > StringBuilder, how is the performance of RS, by making HTML format of
> > email
> > from Report Definition Languge, XML, I know it's compiled, but XML
> > processing
> > is alwasy slow, as I understand. Thanks.
> >
> > Tony
>
>|||Are you integrating RS into your app? If that is the case then the only
difference is whether your app sends it on or Reporting Services does. I
can't tell what you are planning to do. If you are thinking of writing your
own reports in your dotnet app then that is another matter.
I think you are over analyzing this. If you needs are extremely simple then
you can do it yourself. If, however, your reporting is complex at all then
the effort to create your own is huge. RS is very fast when rendering to
HTML and CSV. If you are concerned about performance then send the report in
one of these two format. PDF and Excel is much much slower to render.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tony" <Tony@.discussions.microsoft.com> wrote in message
news:899B34C4-46C3-472F-B283-60C51D365707@.microsoft.com...
> Hi Bruce,
> Thanks for your response. My question is rendering reporting from Report
> Definition Languge comparing to building email body with .NET application.
> My
> guess is XML processing time, hopfully not DOM, but XML stream, comparing
> to
> stringbuilder inside .NET code. In your response, did you mean sending
> email
> or rending will be the same regardless of 2 options? Sorry about can not
> understand the sentence clearly.
> Regards,
> Tony
> "Bruce L-C [MVP]" wrote:
>> What sort of volume are you talking about? Two things are happening:
>> rendering and sending the email. Rendering of the report will be what
>> takes
>> the longest and will be the same regardless of whether you send it via
>> your
>> app or use Reporting Services to email it. So, if you plan on emailing
>> the
>> reports, my guess is the act of sending the email will not make much if
>> any
>> difference as a percentage of the total time.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Tony" <Tony@.discussions.microsoft.com> wrote in message
>> news:3C91238E-5618-4C23-9C1C-7C8BA7199AC1@.microsoft.com...
>> > Hi,
>> > I have 2 options of implementing sending data drivent email to
>> > customers,
>> > one is coding .NET with SMTP, the other is using RS data driven
>> > subscription
>> > with email delivery.
>> > My question is, comparing to .NET code by building email body using
>> > StringBuilder, how is the performance of RS, by making HTML format of
>> > email
>> > from Report Definition Languge, XML, I know it's compiled, but XML
>> > processing
>> > is alwasy slow, as I understand. Thanks.
>> >
>> > Tony
>>|||My report will be sent with HTML format. It's not integrated into my
application. My quesiton was which option is faster at rendering email
message. I think I don't need to worry performance about HTML format, since
you mention it's fast for HTML and CVS. Thanks.
Tony
"Bruce L-C [MVP]" wrote:
> Are you integrating RS into your app? If that is the case then the only
> difference is whether your app sends it on or Reporting Services does. I
> can't tell what you are planning to do. If you are thinking of writing your
> own reports in your dotnet app then that is another matter.
> I think you are over analyzing this. If you needs are extremely simple then
> you can do it yourself. If, however, your reporting is complex at all then
> the effort to create your own is huge. RS is very fast when rendering to
> HTML and CSV. If you are concerned about performance then send the report in
> one of these two format. PDF and Excel is much much slower to render.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Tony" <Tony@.discussions.microsoft.com> wrote in message
> news:899B34C4-46C3-472F-B283-60C51D365707@.microsoft.com...
> > Hi Bruce,
> > Thanks for your response. My question is rendering reporting from Report
> > Definition Languge comparing to building email body with .NET application.
> > My
> > guess is XML processing time, hopfully not DOM, but XML stream, comparing
> > to
> > stringbuilder inside .NET code. In your response, did you mean sending
> > email
> > or rending will be the same regardless of 2 options? Sorry about can not
> > understand the sentence clearly.
> >
> > Regards,
> > Tony
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> What sort of volume are you talking about? Two things are happening:
> >> rendering and sending the email. Rendering of the report will be what
> >> takes
> >> the longest and will be the same regardless of whether you send it via
> >> your
> >> app or use Reporting Services to email it. So, if you plan on emailing
> >> the
> >> reports, my guess is the act of sending the email will not make much if
> >> any
> >> difference as a percentage of the total time.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >> "Tony" <Tony@.discussions.microsoft.com> wrote in message
> >> news:3C91238E-5618-4C23-9C1C-7C8BA7199AC1@.microsoft.com...
> >> > Hi,
> >> > I have 2 options of implementing sending data drivent email to
> >> > customers,
> >> > one is coding .NET with SMTP, the other is using RS data driven
> >> > subscription
> >> > with email delivery.
> >> > My question is, comparing to .NET code by building email body using
> >> > StringBuilder, how is the performance of RS, by making HTML format of
> >> > email
> >> > from Report Definition Languge, XML, I know it's compiled, but XML
> >> > processing
> >> > is alwasy slow, as I understand. Thanks.
> >> >
> >> > Tony
> >>
> >>
> >>
>
>