getdata.xml vs getdata.asp

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Chuck Jungmann (NOchuckSPAM_at_cpjj.net)
Date: 09/06/04 

Date: Mon, 06 Sep 2004 19:59:04 GMT

As I've started to use XML more extensively for data transfer to web
pages, I have started to use the XMLHttpRequest object to get data
from the server. Since I want the data to be returned as XML, I have
been playing around with http: requests to SQL Server. I have also
created ASP pages that return XML after using SQL Server to collect
data.

As far as I know, these two methods are approximately equivalent. ASP
clearly has some important advantages over SQL Http requests,
maintaining session information immediately comes to mind, but does
the convenience of ASP come at a high enough cost that I should
consider using SQL Http requests?

I should clarify the question: I'm your typical geek who loves to
learn and use new technology: I'm inclined to use SQL Http requests
simply because they are new and different and I like how they can help
delegate different logical tasks in my project. Am I wasting my
client's money and my own time looking to SQL Http requests for
performance improvements?

TIA for any light you can shed on this...
Chuck Jungmann

Relevant Pages

  • Database application using XML
    ... I am doing very basic transfer of data and the workhorse is actually in the ASP itself. ... How do I configure SQL Server, ASP and Delphi to work in XML? ... Delphi runs 'SearchRecords.asp' using the TacHTTP/TWebPost component by a defined URL ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Line/Paragraph Breaks in SQL Server/XML output
    ... How exactly are you outputing the file from the Stored Proc? ... the results of a FOR XML query as a string (this changes in SQL Server ... provider to retrieve the XML as a stream or DOMDocument in your ASP script. ...
    (microsoft.public.sqlserver.xml)