>>I'm not sure I have a choice here. I recall I first create a temp text file, then use this file to convert to PDF, not directly from a text string. Lots of extra steps... I questioned today the validity of storing memo as PDF and got these answers:
>>
>>1) We store memo as PDF because we're going to purge Stage tables ~ each six months and we don't want to keep them in our main tables to save space
>>2) We're using PDF because lots of other things are also stored as PDF...
>>
>>===================
>>So, I guess there are not much chances of speeding this particular piece of code...
>
>Maybe you should consider some other tool for PDF creation? I have a process that monthly converts over 1000 pages of FoxPro DOS reports in couple minutes using XFRX PDF library.
>
>13:44:55 Total # of pages to convert 1194
>...
>13:46:11 Total # of Files: 308
>13:46:15 Done.
>
I'll take a look at that. Using TextToPDF through LaunchAppAndWait is quite slow.
If it's not broken, fix it until it is.
My Blog