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 |
|
pinoy_roach
Starting Member
4 Posts |
 Posted - 2004-10-18 : 22:07:43
|
| hi,what is the recommended output in sql server? - rowset returning querries or for xml explicitis there any supporting articles to prove your answer?tnx. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-10-18 : 22:43:15
|
| Depends what you are trying to do, but I can't prove it.Damian |
 |
|
|
pinoy_roach
Starting Member
4 Posts |
Posted - 2004-10-19 : 01:13:55
|
| tnx for the reply.i'm designing a n-tier application in VB ASP SQL Server. I'm thinking on adding XML on it at the database layer.do you have any idea where can i find such information... |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-10-19 : 01:23:49
|
| Are you using XML in your asp ? If you are not, then XML is a bit of a wasted overhead.I never liked using XML to pass data around until .NET, it seemed way too slow and cumbersome.Even then, I tend to build the XML using the rowset that I get back from the database, I think a language like VB or C# is much better at building XML than SQL is.Damian |
|
|
|
pinoy_roach
Starting Member
4 Posts |
Posted - 2004-10-19 : 01:37:54
|
| tnx again.i do get the picture. |
|
|
|
tuenty
Constraint Violating Yak Guru
278 Posts |
Posted - 2004-10-19 : 12:56:41
|
| "...Xml does not optimize for seaching for a node in a document. Nodes can be arbitrarily ordered in the document tree. Nodes cannot be indexed, although they can be sorted. Additionally, your code has to suffer the initial hit of loading the document over from the database, which itself takes time, especially if the database lives far away on the network.""...If your component lives not only on a differnt machine from your databases, but on an etirely different operating system, then XML is the perfect choice for delivering your data..." If not you should use data directly from the database or use an ADO disconnected recordsetThe information was taken from the book Effective Visual Basic-How to improve your vb/com+ applications*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*A candle loses nothing by lighting another candle |
|
|
|
pinoy_roach
Starting Member
4 Posts |
|
|
|
|
|
|
|
Recommend Output (rowset vs for xml explicit)