Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
XMLTOCURSOR too slow
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement