Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
XMLTOCURSOR too slow
Message
De
05/12/2001 13:34:53
 
 
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:
00590022
Vues:
28
Hi Michelle.

>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.

I've run into the same problem. The issue is that XMLTOCURSOR() uses the XMLDOM for parsing, which is pretty slow for large documents. When I mentioned this to Erik Moore at the MVP Summit this past weekend, he suggested looking at the SAX parser, which doesn't load an entire document but instead fires events as it hits each node. I haven't had a chance to look into this yet, but will post something once I do.

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

Click here to load this message in the networking platform