Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Object vs. array?
Message
De
25/08/2009 10:28:23
Gerry Schmitz
GHS Automation Inc.
Calgary, Alberta, Canada
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01420180
Message ID:
01420467
Vues:
72
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform