Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
XMLTOCURSOR too slow
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00589312
Message ID:
00589510
Vues:
32
>I need to pass data from a cursor from one object to another, so I decided to check out XML. It seemed like a perfect fit until I ran it and saw how slow it is.
>
>This line:
>lnNumRecs = XMLTOCURSOR(tcDataString, "tc_addrs")
>
>takes 98 seconds on my Celeron 600 with about 4800 records. Each record has 12 fields. This is way too slow for my needs. Since I'm new to XML, I thought maybe I was just missing a way to optimize it. Is it normal to take this long? Creating the XML from the cursor only takes half a second. What am I missing?
>
>Thanks,
>
>Michelle




No XML is not really implemented well in VFP for large data sets. 100, no problem. 5000, I'd think of an FTP solution.

__Stephen
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform