Hi Simon,

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