Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow Speed of XMLToCursor
Message
From
25/10/2004 12:21:41
 
 
To
25/10/2004 05:02:17
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00953840
Message ID:
00954307
Views:
12
Nice tip, Aleksey. I was having the same issue.

Should not PreserveWhiteSpace default be .T. ?

>Preserve white space setting makes a big difference. I've done a simple test, XMLAdapter parses 500Kb xml file about 20 times faster if PreserveWhiteSpace is set to .T. (there is a similar flag for XMLTOCURSOR). Also, the size of XML can be decreased by switching off formatted output.
>
>Thanks,
>Aleksey.
>
>>Hi
>>
>>It appears to me that XMLToCursor is really only useable for a small number of records. For example I had a table with 6600 records in it which needs to be sent to a web server via XML. The XML file is 1.8meg and is easly sent to the web server but using XMLToCursor to save the data back to a VFP table is very slow. It takes ~110 seconds to create the temporary cursor on my 2.6ghz workstation. So the web request usually times out before everything is complete. CursorToXML is quite fast since it only took .15sec to create the same XML file.
>>
>>The reason I need to do this is that I have client with firewall restrictions that require data synchronization and the only way to do this is to send the complete table to the web site so it can be saved thus updating the data on the server.
>>
>>So I am wondering what people are doing if they need to send larger files with more records using XML.
>>
>>I have resorted to sending the data as a Zipped DBF which works very nicely.
>>
>>Regards,
>>Simon
- Jeff
Previous
Reply
Map
View

Click here to load this message in the networking platform