Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Image Save as
Message
 
To
22/11/2006 04:00:59
General information
Forum:
Visual FoxPro
Category:
Pictures and Image processing
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01171658
Message ID:
01171718
Views:
7
Hi Tore,
> StrToFile(yourblobfield,'yourfile.zzz')
FYI. Depending on the size of the binary, I have noticed an 8x-10x increase in speed by using the COPY MEMO command to retrieve BLOB fields to files, as compared to using the STRTOFILE function.

I wasn't sure if many were aware that this command works with BLOB fileds also and is not nearly as memory intesive.
COPY MEMO myblobfield TO "myfile.zzz"
NOTE: Using APPEND MEMO versus REPLACE...FILETOSTR does not have the same noticible difference.
Previous
Reply
Map
View

Click here to load this message in the networking platform