>Why the function XMLTOCURSOR() it's so slow ?
>If the xml string is little it's seem fast but as soon the XML string grows the function becomes very very slow.
>An example : XML string of 5mb == 20 minutes to convert in a cursor (in a local computer).
>I know that FOX read the string two times but it seems however still too much slow.
>
>I forgot: CURSORTOXML(), instead, it's very fast
One way to speed things up is to provide a schema (in fact, this should always be the case to prevent wrong assumptions over data types). XML parsing of files that large will always be a slow process, I think.
----------------------------------
António Tavares Lopes