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 |
|
dbuser123
Starting Member
20 Posts |
 Posted - 2005-12-25 : 13:38:34
|
| The server returns an answer to a query as an XML String. I load the XML String into a Recordset on the win32 client side.as hr = pXMLDom.CreateInstance(__uuidof(DOMDocument30)); pXMLDom->loadXML(_bstr_t(lpwszStream)); m_Rec.CreateInstance(__uuidof(ADODB::Recordset)); m_Rec->Open(pXMLDom.GetInterfacePtr(),vtMissing,ADODB::adOpenStatic,ADODB::adLockReadOnly,ADODB::adCmdFile);But thie open operation for 1000 records takes 2 seconds. I think that is very very slow. Anything that I can do to speed this up ? |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-12-27 : 09:02:01
|
| If this is .NET you should post in the .NET forum.How much data is 1000 records? |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-12-27 : 09:32:29
|
why do you return xml from the server and then convert it back to recordset?IMO 2 secs isn't that slow for old ado.Go with the flow & have fun! Else fight the flow  |
|
|
|
|
|
|
XML String into ADO Recordset