Is this Impossible !!

[Thomas B. Passin]

From: AlanM <AlanM at SYNECTICS.Soft.net>


>
>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 at ic.ac.uk
Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/ and on CD-ROM/ISBN 981-02-3594-1
To unsubscribe, mailto:majordomo at ic.ac.uk the following message;
unsubscribe xml-dev
To subscribe to the digests, mailto:majordomo at ic.ac.uk the following message;
subscribe xml-dev-digest
List coordinator, Henry Rzepa (mailto:rzepa at ic.ac.uk)