MS SQL Server - to use or not to use XML

Author

to use or not to use XML

bajopalabra

2005-08-11, 1:23 pm

hi
i go to call a stored proc
passing a xml text parameter
and then split it into a #tmp table
with OPENXML

some people says that way
is inefficient , slow, resource consuming , etc etc

my question is :
to use or not to use XML
in order to get an "array" parameters ?

how much overload is actually cast to the server ?

--
atte, Hernán

Wayne Snyder

2005-08-11, 8:23 pm

Alot of this depends on your sensitivity to performance and how frequently
this will run.. However, If these XML files are relatively small, it should
not be a big deal. But since this is text manipulation as they grow larger
you can get into problems... Also be aware that the DOM tree which is
generated by this MUST exist in memory... So if you have lots and lots of
concurrent users and are passing large documents , you could also get a
problem related to memory

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

"bajopalabra" <bajopalabra@hotmail.com> wrote in message
news:OEWuuqonFHA.2472@tk2msftngp13.phx.gbl...
> hi
> i go to call a stored proc
> passing a xml text parameter
> and then split it into a #tmp table
> with OPENXML
>
> some people says that way
> is inefficient , slow, resource consuming , etc etc
>
> my question is :
> to use or not to use XML
> in order to get an "array" parameters ?
>
> how much overload is actually cast to the server ?
>
> --
> atte, Hernán
>
>

bajopalabra

2005-08-11, 8:23 pm

thanks
i just want to get a few bytes of xml text
for simulate passing a an array of keys, like:

<doc>
<key value="10204"></key>
<key value="35404"></key>
<key value="989"></key>
</doc>

(not much frequently)
do you see any problem here ?

--
atte, Hernán

"Wayne Snyder" <wayne.nospam.snyder@mariner-usa.com> escribió en el mensaje
news:uHdn6QsnFHA.3020@TK2MSFTNGP10.phx.gbl...
> Alot of this depends on your sensitivity to performance and how frequently
> this will run.. However, If these XML files are relatively small, it
should
> not be a big deal. But since this is text manipulation as they grow larger
> you can get into problems... Also be aware that the DOM tree which is
> generated by this MUST exist in memory... So if you have lots and lots of
> concurrent users and are passing large documents , you could also get a
> problem related to memory
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
>
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "bajopalabra" <bajopalabra@hotmail.com> wrote in message
> news:OEWuuqonFHA.2472@tk2msftngp13.phx.gbl...
>
>

Sponsored Links