Page 1 of 1

increase performance

Posted: Mon Sep 02, 2013 11:34 am
by ramesh55
hi,
I am using below code to generate pdfs passing soa_id one by one.but here to generate 1000 pdfs or htmls its consuming 25 minutes.here its consuming time to compile every time.Is there any alternative ,or reduce code from below.

I have followed links which were sent by you to reduce time in mrt designing. i need the time reducing in .cs

foreach (DataRow DR in ds.Tables[0].Rows)
{
objStiReport.DataSources["Reportvalues"].Parameters["soa_id"].Value = DR["soa_id"].ToString(); //passing arguments
// objStiReport.DataSources["Reportvalues"].Parameters["Addresstype"].Value = "BIL"; //passing arguments

objStiReport.Compile();
objStiReport.Render(true);
StiorderDetail.Report = objStiReport;
StiorderDetail.Report.ExportDocument(StiExportFormat.Html, Server.MapPath("~/Reports/OrderDetails/" + DR["soa_id"].ToString() + "_1.html"), objStiPdfExportSettings); // generating pdf file in a given location
StiorderDetail.Dispose();
}

Re: increase performance

Posted: Mon Sep 02, 2013 1:41 pm
by Alex K.
Hello,

Can you please send us a sample project which reproduce the issue for analysis.

Also please try to see the following series of articles about optimization reports on our blog:
part 1:
http://blog.stimulsoft.com/articles/optimizing-reports
part 2:
http://blog.stimulsoft.com/articles/opt ... rts-part-2
part 3:
http://blog.stimulsoft.com/articles/opt ... rts-part-3

Thank you.

Re: increase performance

Posted: Tue Sep 03, 2013 4:59 am
by ramesh55
Hi,

PFA

In attached file, mrt file exists in reports folder and code exists in default.aspx.

If u find any code or mrt related changes please give me the steps one by one.

for me to generate 1000 htmls or pdfs it consuming 24 minutes of time. but for the same, crystal reports are consuming only 6
minutes.please give me a solution to achieve the same in stimulsoft in 6 or lesser than that time.

Re: increase performance

Posted: Tue Sep 03, 2013 6:20 am
by Alex K.
Hello,

It is difficult to give any advices without test data. Can you please provide a test data for your project.

Thank you.

Re: increase performance

Posted: Tue Sep 03, 2013 6:59 am
by ramesh55
how can i give u the test data, in the form of db or in what?

Re: increase performance

Posted: Tue Sep 03, 2013 8:47 am
by HighAley
Hello.

As a way, you can use the following code in the BeforePrint event of a page and sent us the files you get.

Code: Select all

{YourDataTableName}.DataTable.DataSet.WriteXml("e:\\data.xml");
{YourDataTableName}.DataTable.DataSet.WriteXmlSchema("e:\\data.xsd");
Thank you.