|
|
You're in the
sql server reporting services
group:Performance of RS email delivery VS .NET code email with SMTP
sql server reporting services:
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.
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 [quoted text, click to view] "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 > > from Report Definition Languge, XML, I know it's compiled, but XML > > processing > > is alwasy slow, as I understand. Thanks. > > > > Tony > >
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 [quoted text, click to view] "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 > 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 [quoted text, click to view] "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 > 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 >> > 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 [quoted text, click to view] "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 > > 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 > >> > from Report Definition Languge, XML, I know it's compiled, but XML > >> > processing > >> > is alwasy slow, as I understand. Thanks. > >> > > >> > Tony > >> > >> > >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |