Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XMLtoCursor Parse Error
Message
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01356612
Message ID:
01356674
Views:
27
83% sounds reasonable.

>
>That makes sense. I am basically compressing XML files storing in a cursor with Blob field, and compressing the resulting cursor. Looks like doing this will gain me approximately 83% time savings in transferring data over a vpn connection to speed up database synchronization compared to not doing the compression. Hence the compression string would be binary.
>
>>The CURSORTOXML() considers Blob, Memo/Binary and varbinary to be a binary data and uses BASE64 encoding on them. The BASE64 encoding will increase the size by about 30%.
>>The Memo is a character field and is included in XML w/o changes. A binary data in a memo will cause XML to become invalid.
>>You cannot expect 28MB of data to be compressed into 4KB. Most likely 4KB file was truncated.
>>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform