XmlDocument Cache / SQL Server nText Speed Enhancement
For starters, it is Independence Day! Take a few moments to reflect on the sacrifices made by those who came before you. Without their efforts, you wouldn 't be breathing free air right now. You might be speaking German, Russian, Japanese or perhaps withering away under the heels of communism instead. With that in mind, the next time you see a veteran, stop and just say thank you. They 've earned your respect and deserve your thanks. Enjoy the holiday!
As you may have read in some of my other articles here on EggHeadCafe.com (Web Service vs Web Workspace Part I), I spend a great deal of time writing software and websites that center around research and analysis methodologies for Gartner. Much of this data is hierarchial in nature and seldom is relational across multiple analysis models. Thus, one study doesn 't really relate to another one from a database perspective.
In previous versions of our software, we often stored the data relationally in Access, SQL Server, or Oracle. This forced us to have to execute expensive queries across large numbers of records that didn 't really relate to one another, load the data in some form of hierarchial structure either with ADO or COM object trees, work with the data, and then run expensive updates across myriads of records with varying data types. In a desktop environment, you can get away with the extra overhead. Performing these same complex tasks via a web site is a