Thanks David, so? do we have a bug?, there is a huge perfomance penalty with XMLToCursor(). To solve my problem, I have to change the way I get and return my results, but I don't want to do it.

>XMLToCursor is most definately not linear in performance. Try this test code:

>function BigXMLTest( n )

>close databases all

>create cursor x1 ( i1 i, c1 c(10), t1 t, i2 i )

>for i = 1 to n
>   insert into x1 values ( i, str(i), datetime(), int( rand() * 100000 ) )
>endfor

>? n
>i = seconds()
>cursortoxml( "x1", "x1.xml", 1, 0 + 512, 0, "1" )
>?? seconds() - i

>close data all

>i = seconds()

>xmltocursor( "x1.xml", "x2", 512 )
>?? seconds() - i

>CursorToXML() is linear in performance.

>n CursorToXML XMLToCursor
> 1000 0.083 1.427
> 2000 0.165 4.7
> 3000 0.254 9.9
>10000 0.874 150.0

>df - Microsoft MVP, MCP

>df FoxPro website last update 21-Jul-01
>FoxPro Wiki site online, edittable knowledgebase
>Microsoft public newsgroups
>DevX newsgroups