1. 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?


Marco Meoni Accepted Answer Pending Moderation
  1. Friday, 20 October 2017 12:04 PM UTC
  2. PowerBuilder
  3. # 1


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?



  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 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

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.