Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
izaltsman
A custom title
1139 Posts |
 Posted - 2002-11-27 : 17:14:10
|
| Hi All!I just wanted to see if anyone out there is actively using SQLXML in a production environment. If you are using it, please share your experiences with this technology. I am interested in any insight you might have regarding security, efficiency and scalability of solutions that expose SQL stored procs as webservices using SQLXML. I would also appreciate links to any relevant resources on the web. |
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2002-11-27 : 18:07:27
|
| Ilya,We are using several features of SQLXML in a few production environments, including Updategrams, template file queries, and XDR/XSD xpath queries. One environment makes almost exclusive use of SQLXML for all data access queries. We've found that template file queries are scalable enough for a relatively high volume environment, but updategrams and xdr/xpath queries were kinda slow. In every profiler trace we saw, it seemed that the SQLXML extensions translated everything to nvarchar fields before sending the SQL to the database.Because SQLXML is really no more than ISAPI extension to IIS, it's security is somewhat dependent on how solid your IIS security settings are. We found that it was quite a hassle to get the security settings tight and still be able to function correctly.I continue to use SQLXML for client-side scripting in intranet environments, mostly data reading and display, but we've moved onto different (better?) methods for server-side development. We have written many of our SQL 2000 queries using FOR XML EXPLICIT, and we can leverage that code directly from the web client.To be honest though, I haven't used the technology for several months. DotNET web services have supplanted the need for SQLXML in our experience.One tech resource that helped us in the past was [url]http://www.sqlxml.org/[/url].-- monkey |
 |
|
|
|
|
|
|
|
SQLXML