>Consider a scenario where you have 1000 records that are about 500 bytes >each. If it's in a database, it's already in a read-optimized format >that can be quickly queried and send back only the needed results. With >XML, you'd first need to read the WHOLE file (500k+, with tags) from >disk, run the read text through CF's XML parser, then run Xpath or >something to retrieve the part you need.
Use SAX then. Extremely quick. I've used SAX on 20 meg XML files with awesome results. Too bad CF doesn't directly support SAX (yet). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182861 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54