How could you explain this?

S

s_alexander04

Hello

I've experienced a very low speed filling DataSet in program running on
PocketPC and connected to SQL Server via Wireles Lan. I used
SqlDataAdapter. Table basically consists of text fields of type
nvarchar and has about 6000 rows. It takes about 5 minutes to fill
DataSet using SqlDataAdapter.Fill.
Then I wrote a stored procedure which created a temporary table
inserting there fields from the initial table and converting them from
nvarchar to varchar.
And now from resultset of this procedure SqlDataAdapter fills DataSet
8-9 times faster!
I've expected 2 times increase in better case.
Why is there such increase of speed? Maybe because SqlDataAdapter or
DataSet makes something like a re-encoding when filling and there is a
way to avoid this not converting nvarchar to varchar?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stored procedure works with datareader but not with dataset 2
missing column in my sproc call 2
Help: Bulk insert with ADO.NET from outside database 5
How to navigate recursive stored procedures results 5
Help: How do u get primary key from a dataset after update inserts new row? 8
How to read a DataSet? 1
DataBinding a ListBox's SelectedValue to integer field from DataSet gives error 4
"IF" test in SP evals to True and False at same time using DataAdapter.FillSchema() 7

Top