G
Guest
Hi SQL Gurus,
I have a scenario like following:
My DAL is sitting on a BOX with 4 GB RAM and calling the SQL Server BOX via
Network (Internal). The records returned are huge in range of say 30000 to
300000.
I am having 6 Columns on average in each row.
I am generating an XML in a SQL Server 2005 Stored Procedure using 'For XML
Path' the result of this Select is a Single row/line returning the entire XML.
Now, given the above statistics, I am in doubt what specific feature of
ADO.Net to go for:
1. DataTable: which will pull the entire ResultSet at one go (which is
effective connection usage n network usage wise, but inefficient on Memory
consumption part)
OR
2. RecordSet: which will keep connection locked until the entire data is
passed or RecordSet is closed. Given the number of records 30000 to 300000,
this will again make that many network hops, but is much liter on the Memory
Consumption side.
I want my application to be Scalable and High Performing, what thing to go
for in the scenario like above.
I really appreciate any help on this.
Thanks,
Sachin R. Chavan.
I have a scenario like following:
My DAL is sitting on a BOX with 4 GB RAM and calling the SQL Server BOX via
Network (Internal). The records returned are huge in range of say 30000 to
300000.
I am having 6 Columns on average in each row.
I am generating an XML in a SQL Server 2005 Stored Procedure using 'For XML
Path' the result of this Select is a Single row/line returning the entire XML.
Now, given the above statistics, I am in doubt what specific feature of
ADO.Net to go for:
1. DataTable: which will pull the entire ResultSet at one go (which is
effective connection usage n network usage wise, but inefficient on Memory
consumption part)
OR
2. RecordSet: which will keep connection locked until the entire data is
passed or RecordSet is closed. Given the number of records 30000 to 300000,
this will again make that many network hops, but is much liter on the Memory
Consumption side.
I want my application to be Scalable and High Performing, what thing to go
for in the scenario like above.
I really appreciate any help on this.
Thanks,
Sachin R. Chavan.