Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
XMLTOCURSOR too slow
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
XMLTOCURSOR too slow
Divers
Thread ID:
00589312
Message ID:
00589312
Vues:
95
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform