Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Retrieving large xml recordset through ADO
Message
De
13/03/2003 16:02:43
Leo Kool
Agis Automatisering BV
Harmelen, Pays-Bas
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00765479
Message ID:
00765582
Vues:
35
Kurt,

Thanks for your reply, but it's not actually what I'm looking for, because I want to be able to format the XML to my own needs.
I'll take a look at the Foxpro Advisor article, thanks for mentioning.

Leo
>Leo,
>
>Have you looked into using the RecordSet.Save() method. This will save the contents of the recordset to a file, then you can read the file into a string. This should be much faster than manually creating the string, however you won't be able to format the XML to your own needs.
>
>
>
>loRs.Save('C:\xmldata.xml',1)
>lcXml = FILETOSTR('C:\xmldata.xml')
>
>
>
>This month's issue of Foxpro Advisor also has an article on speeding up strings with XML by writing large amounts of data out to a file instead of writing to a memory variable, however through my testing, the above method is still much faster.
>
>Hope this helps,
>Kurt
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform