On Fri, Jul 9, 2010 at 4:40 PM, Michael Grant <mgr...@modus.bz> wrote:
> > > > > > Good thing I started handing off most of my XML reply messages from > > API's straight to MS SQL server, so much simpler ;-) > > > > Especially if you're working with a large xml result set. It's soooo quick > to just stick it straight into the db. > > No kidding, I had a task that was timing out, then did some research on XML inside MS SQL, now it takes about 3 seconds if that I think it takes longer to receive the reply from the API then it does for SQL server to insert the records. Took a bit to grasp it, but wow, it's totally changed how I think about managing XML Even storing the straight XML in a column under XML data type is super cool! it creates a link in Management studio that when clicked opens the XML in a new window all color formatted and stuff. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335220 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm