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?

just in case
it is VS2003 C# SmartDevice Application

Empty Parameter
Store procedure vs Direct statement ???
UniqueIdentifier Sql Data and Parameters
Storing wave files in database
Dataset, SqlDataAdapter, memory and you in .net 2