Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I wish I would have known how slow it was before I got this far. It's too bad because it's really a neat way to pass data around. I'll keep an eye out for your post.
Thanks,
Michelle
>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
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