http://www.sqlservercentral.com/Content tagged T-SQL, Programming, XML, Basics posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it! http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart2/588/2002/02/06http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart2/588/This sample is provided in conjunction with the MSDN Magazine article, "SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web." This article presents and compares five data access approaches, using a variety of technologies including ASP and ADO, XSLT, and DirectXML. Once built, the solutions are compared on the basis of their speed and efficiency. http://www.sqlservercentral.com/redirect/articles/575/2002/01/18http://www.sqlservercentral.com/redirect/articles/575/