Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Generating a PDF in-memory

  1. Issue
0
Votes
Undo
  1. Roland Smith
    Roland Smith
  2. PowerBuilder
  3. Thursday, 19 October 2017 13:48 PM UTC

I have a process (PB 12.5.2) which generates a PDF of tax forms and saves them to the database for viewing later.

The process is slow so I am looking for a method for generating the PDF entirely in-memory. I would then use UPDATEBLOB to save it in the database.

Any ideas?

 

  1. PDF
Appeon 2017 Pipelines in 64bit
AutoCompile 17.0
Responses (2)
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Friday, 20 October 2017 12:04 PM UTC
  2. PowerBuilder
  3. # 1

Hi,

What step is slow?

1) Retrieve the DW/DS

2) SaveAs(PDF)

3) Read PDF back into blob

4) Store blob to DB

Provided 1) and 4) won't be affected by any future in-memory Appeon API, it is hard to imagine that 2) and 3) may represent the significant portion of the overall time consumption.

I mean, I agree in-memory generation can save some time and some PB code, but how many MBs can possibly be your PDF to benefit from skipping those 2 steps?

Cheers,

Marco

Comment
Roland Smith
  1. Roland Smith
  2. Saturday, 21 October 2017 01:47 AM UTC
I haven't timed it myself so I can't say for sure but certainly file i/o will be a significant bottleneck. When you have to generate up to 5000 one page PDF files that have a PNG image file in the background, anything you can do to speed it up will be a big help.



I am currently testing out an ActiveX control I used in the past with Classic ASP. I load a blank PDF form into the control, write text strings to it, and then return the form into a blob variable. The whole process takes only 0.02 seconds. The only downside is you have to code a line to write each string to the form and figure out the coordinates.

  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 19 October 2017 15:11 PM UTC
  2. PowerBuilder
  3. # 2

Hi Roland;

  That would be a great enhancement IMHO to the Appeon PB native PDF feature!

May I suggest that you open a support ticket for that enhancement?

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.