On Wed, 22 Oct 2003 11:59:15 -0500, "Jay" <ja**********@hotmail.com>
wrote:
It seems to me that when I retrieve large amounts of XML data using Visual
Basic 6 (lets say 900 records 20 fields), processing seems to slow way down.
A DOM holds the entire XML document in memory, a relational database
will hold it on disk and just load pages as required. You can imagine
the effects for yourself, when single documents become large.
XML DOM's are a good way to manipulate data, and not a bad way to
extract pieces from a larger working set. But when your potential
source set is really big, then it's not the best technology to choose.
Try building a smaller document (or even several of them) as the
result of a database query, and only put into it what you need.
--
Die Gotterspammerung - Junkmail of the Gods