Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XMLToCursor limits
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00669425
Message ID:
00669549
Views:
22
This message has been marked as a message which has helped to the initial question of the thread.
Esparta,

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 (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform