By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,278 Members | 1,136 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,278 IT Pros & Developers. It's quick & easy.

need advice

P: n/a
Hello:
I have on sql 2000 a stored procedure that I call from a webs ervice.
I was returning a dataset, but the overhead is killing me: I need to return
about 3000 records and it is taking too long.
.... and I dont need to return a dataset. I might try a datatable..
I tried returning a SqldataReader but that failed with: To be XML
serializable, types which inherit from IEnumerable must have an
implementation of Add(System.Object) at all levels of their inheritance
hierarchy. System.Data.SqlClient.SqlDataReader does not implement
Add(System.Object).

I was thinking about getting SQL 2000 to return an XML object but in it's
first implementation of XML, performance was not great either.

Question: I do not want to do any data manipulation - only return to the
consumer the data from the stored procedure in the quickest way possible.
What does your experience suggest I look at.

Thanks

Oct 6 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"GADOI" <su*****@oci.comwrote in message
news:AA**********************************@microsof t.com...
Hello:
I have on sql 2000 a stored procedure that I call from a webs ervice.
I was returning a dataset, but the overhead is killing me: I need to
return about 3000 records and it is taking too long.
... and I dont need to return a dataset. I might try a datatable..
I tried returning a SqldataReader but that failed with: To be XML
serializable, types which inherit from IEnumerable must have an
implementation of Add(System.Object) at all levels of their inheritance
hierarchy. System.Data.SqlClient.SqlDataReader does not implement
Add(System.Object).

I was thinking about getting SQL 2000 to return an XML object but in it's
first implementation of XML, performance was not great either.

Question: I do not want to do any data manipulation - only return to the
consumer the data from the stored procedure in the quickest way possible.
What does your experience suggest I look at.
I suggest that you determine where the performance problem is located before
you try to solve the problem. Most likely, the problem is in fetching the
data from the database, not in storing it in a DataSet or in returning the
DataSet to the client.

How long does it take to just read the data but not put it into a DataSet?

Also, a DataTable is the same thing as a DataSet with only a single table.

--
John Saunders | MVP - Connected System Developer

Oct 6 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.