Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Object vs. array?
Message
From
25/08/2009 10:28:23
Gerry Schmitz
GHS Automation Inc.
Calgary, Alberta, Canada
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01420180
Message ID:
01420467
Views:
74
>The XMLToCursor() could get slow with more than a hundred records depending on a number of fields.
>
>>Why not try it the ".NET" way?
>>
>>CursorToXML() and XMLToCursor() can blast a cursor or table to a file or memvar (i.e. string) and back again in no time; e.g.
>>
>>
>>m.foo = ""
>>use MyDbf
>>CursorToXML("MyDbf", "m.foo", 3)
>>XMLToCursor(m.foo, "BOPlenty")
>>browse
>>
>>
>>Note the use of "output format option 3" (attribute centric XML) which uses around 40% less markup than element centric.

I was using a 200+ record / 130K table and it didn't even blink ... (the resulting XML was 230K ). Smaller than an array using Fabio's numbers.
Previous
Reply
Map
View

Click here to load this message in the networking platform