Re: Is this Impossible !!
From: AlanM <AlanM@S...> > >Hi guys, >Since speed is criteria is it faster to send Queries to the server in SQL or >XML. If sent in XML we will have to parse it and then convert it into SQL >again, which may slow down the process. > > "Speed" is relative. If the query is complex and there is a lot of data, the time for the database to return the results will probably dominate the response time. If so, the time to convert into/out of XML would be unimportant. Conversely, if the normal queries got a very quick return from the database, the XML-query-conversion time might win. Also, the time to connect to the database could be significant. So there might be more than one answer to this, depending on your particular case. As an aside, there have been a number of efforts in the past to specify SQL as a general query language independent of any type of database. So it is not unreasonable to think of using it instead of XPATH strings, whatever the form of the data storage. Of course, either translating SQL into XPATH strings or vice versa is going to be a substantial effort for general or complex queries, no matter how you slice it. Thomas Passin xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev@i... Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/ and on CD-ROM/ISBN 981-02-3594-1 To unsubscribe, mailto:majordomo@i... the following message; unsubscribe xml-dev To subscribe to the digests, mailto:majordomo@i... the following message; subscribe xml-dev-digest List coordinator, Henry Rzepa (mailto:rzepa@i...)
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format