SQL Server 2000 . Optimizing SQLXML Performance

Optimizing SQLXML Performance.

How to optimize SQLXML performance for databases, including SQL Server 2000. (12 printed pages)

Download Optimizingsqlxmlsampleapp.exe.

Dim cmd as ADODB.Command
Dim con as ADODB.Connection
Dim instrm as ADODB.Stream
Dim outstrm as ADODB.Stream

instrm.Open
instrm.LoadFromFile("d:\Templates\SQLXMLWR3\TemplateWithXPath\
  customers_orders_template.xml")

outstrm.Open

Set con = new ADODB.Connection
con.open("provider=sqlxmloledb;data 
provider=sqloledb;server=(local);integrated 
security=true;database=northwind")

Set cmd = new ADODB.Command
cmd.ActiveConnection = con
cmd.CommandStream = instrm
cmd.Dialect = "{5d531cb2-e6ed-11d2-b252-00c04f681b71}"
cmd.Properties("Output Stream").Value = outstrm
cmd.Properties("Base Path").Value = "d:\Schemas\SQLXMLWR3\ 
TemplateWithXPath\"
cmd.Properties("Mapping Schema").Value = "mySchema.xml"
cmd.Properties("Output Encoding") = "utf-8"

cmd.Execute , , adExecuteStream
This entry was posted in XML / XSL. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s