Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is faster: insert from memvar or insert fields?
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01139366
Message ID:
01141047
Views:
33
>>>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.

I have more or less generic class for that.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform