Ggthjy

I am trying to build a application that creates PDF and saves in local file. I am using this through iTextSharp in C#. I need to save at least 1 lac (100,000) PDF files.

After 10,000 files the saving gets slow. The first 10k gets saved in 2 mins, rest of the files take almost 5 hours.

I believe the issue is usage of memory. But I could not find a solution to fix that issue. I have posted the source code.

private void CreatePDF11()

{

    Queue<String> QTempFileNames;

    QTempFileNames = new Queue<string>();

    string fileName = string.Empty;



    DateTime fileCreationDatetime = DateTime.Now;



    fileName = @"D:StatementMassPrinttesystw14j414435.PDF";



    string DestinationDirectory = @"D:StatementMassPrint";



    string StrTempFilePath = String.Empty;



    string pdfPath = fileName;



    int TempPdfFileName = 1;

    if (DestinationDirectory != string.Empty)

    {

        StrTempFilePath = DestinationDirectory + "temp" + "(" + DateTime.Now.ToFileTime() + ")";

    }



    if (!(Directory.Exists(StrTempFilePath)))

    {

        Directory.CreateDirectory(StrTempFilePath);

    }

        string reportFileName = StrTempFilePath + "\" + TempPdfFileName.ToString() + ".Pdf";



        for (int f = 0; f < 100000; f++)

        {

            reportFileName = StrTempFilePath + "\" + TempPdfFileName.ToString() + ".Pdf";



            using (FileStream msReport = new FileStream(reportFileName, FileMode.Create))

    {

        //step 1

        using (Document pdfDoc = new Document(PageSize.A5.Rotate(), 10f, 10f, 200f,40f))

        {

            try

            {

                // step 2

                PdfWriter pdfWriter = PdfWriter.GetInstance(pdfDoc, msReport);

                pdfWriter.PageEvent = new EpisodePageHeaderAndFooter();



                //open the stream 

                pdfDoc.Open();



                DataTable dtEpisodeWise = new DataTable();

                dtEpisodeWise.Columns.Add("INVOICE_NO");

                dtEpisodeWise.Columns.Add("INVOICE_DATE");

                dtEpisodeWise.Columns.Add("CODE");

                dtEpisodeWise.Columns.Add("SERVICE_DESCRIPTION");

                dtEpisodeWise.Columns.Add("QTY",typeof(decimal));

                dtEpisodeWise.Columns.Add("UNIT_PRICE",typeof(decimal));

                dtEpisodeWise.Columns.Add("GROSS",typeof(decimal));

                dtEpisodeWise.Columns.Add("DISCOUNT",typeof(decimal));

                dtEpisodeWise.Columns.Add("NET",typeof(decimal));

                dtEpisodeWise.Columns.Add("DEDUCTION",typeof(decimal));

                dtEpisodeWise.Columns.Add("NET_PAYABLE_WITHOUT_VAT",typeof(decimal));

                dtEpisodeWise.Columns.Add("VAT",typeof(decimal));

                dtEpisodeWise.Columns.Add("NET_PAYABLE_WITH_VAT",typeof(decimal));



                PdfPTable table = new PdfPTable(dtEpisodeWise.Columns.Count);

                table.WidthPercentage = 100;



                Font fontH1 = new Font(Font.FontFamily.HELVETICA, 6, Font.BOLDITALIC);

                for (int k = 0; k < dtEpisodeWise.Columns.Count; k++)

                {



                    string str = System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(dtEpisodeWise.Columns[k].ColumnName.Replace("_", " ").ToLower()); ;

                    PdfPCell cell = new PdfPCell(new Phrase(str,fontH1));

                    cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;

                    cell.VerticalAlignment = PdfPCell.ALIGN_CENTER;

                    //    cell.BackgroundColor = new iTextSharp.text.BaseColor(51, 102, 102);



                    table.AddCell(cell);

                }



             //   for (int i = 0; i < 1000; i++)

             //   {

                    dtEpisodeWise.Rows.Add("CR100005", "25-05-1989", "CPT004", "SERVICE005", 1, 10, 100, 10, 90, 45, 45, 5, 50);

                    dtEpisodeWise.Rows.Add("CR100006", "25-05-1992", "CPT00555", "SERVICE105",6, 60, 600, 60, 450, 45, 45, 5, 500);



             //   }



                Font fontH2 = new Font(Font.FontFamily.HELVETICA, 6, Font.ITALIC);



                for (int i = 0; i < dtEpisodeWise.Rows.Count; i++)

                {

                    for (int j = 0; j < dtEpisodeWise.Columns.Count; j++)

                    {



                        PdfPCell cell = new PdfPCell(new Phrase(dtEpisodeWise.Rows[i][j].ToString(),fontH2));



                        //Align the cell in the center



                        if (dtEpisodeWise.Columns[j].DataType == typeof(decimal))

                        {

                            cell.HorizontalAlignment = PdfPCell.ALIGN_RIGHT;

                            cell.VerticalAlignment = PdfPCell.ALIGN_CENTER;

                        }

                        else

                        {

                            cell.HorizontalAlignment = PdfPCell.ALIGN_LEFT;

                            cell.VerticalAlignment = PdfPCell.ALIGN_CENTER;

                        }



                        table.HeaderRows = 1;



                        table.AddCell(cell);

                    }

                }

                    pdfDoc.Add(table);



                pdfDoc.Close();

                TempPdfFileName++;







            }



            catch (Exception ex)

            {

                //handle exception

            }



            finally

            {





            }



        }



    }

}





}

```