| Author |
openxml - streams the xml or loads it all in to memory?
|
|
| McGeeky 2005-09-30, 9:23 am |
| Does SQL Server stream the xml when using the open xml facility or does it
load the entire xml document in to memory?
I will be sending some pretty large xml documents to SQL Server for
processing by open xml. But if SQL Server doesn't stream it I'll have to
think again.
Thanks.
--
McGeeky
http://mcgeeky.blogspot.com
| |
| Michael Rys [MSFT] 2005-10-01, 8:23 pm |
| OpenXML does load it into its memory (although it will be using the SQL
Server buffer and does has some disk backing).
If you have really large XML documents, I would recommend to look at the
SQLXML 3.0 XML Bulkload facility.
Best regards
Michael
"McGeeky" <anon@anon.com> wrote in message
news:uBYNQZcxFHA.1412@TK2MSFTNGP09.phx.gbl...
> Does SQL Server stream the xml when using the open xml facility or does it
> load the entire xml document in to memory?
>
> I will be sending some pretty large xml documents to SQL Server for
> processing by open xml. But if SQL Server doesn't stream it I'll have to
> think again.
>
> Thanks.
>
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
>
>
| |
| McGeeky 2005-10-03, 7:24 am |
| I have to do processing on the XML though so I can't use the bulk load
unfortunately.
Knowing that SQL Server loads the XML in to memory means that I'll be
batching up the XML in chunks rather than sending the whole lot at once to
keep the memory footprint light.
Thanks for the info.
--
McGeeky
http://mcgeeky.blogspot.com
"Michael Rys [MSFT]" <mrys@online.microsoft.com> wrote in message
news:uyzJlnsxFHA.2960@tk2msftngp13.phx.gbl...
> OpenXML does load it into its memory (although it will be using the SQL
> Server buffer and does has some disk backing).
>
> If you have really large XML documents, I would recommend to look at the
> SQLXML 3.0 XML Bulkload facility.
>
> Best regards
> Michael
>
> "McGeeky" <anon@anon.com> wrote in message
> news:uBYNQZcxFHA.1412@TK2MSFTNGP09.phx.gbl...
>
>
|
|
|
|