Q: Improvements in VS2005?

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

Hi

Can anybody tell me if there has been any significant improvement in the
speed that rows from a dataset in a client can be transferred i.e. updated,
to a database on a Server?

The reason I ask is that using VS2003 I have created a dataset via a table
in on the Server, added several hundred rows to it, used the update command,
and it works - just a little slowly!!!

Does anybody know if things have improved in the latest version?

Thanks in advance

Geoff
 
IMO your best bet is to give this a try yourself (the 2.0 NET Framework and
the Express product are free) as it could well depend from some specific
conditions (such as the database you are using).

From where are all those records copied ? If they come from some other
source you could perhaps add them directly server side from this source
instead of passing them client-side through a DataTable.

If this is for SQL Server you could perhaps use the XML bulk insert
functionality that is available in 1.1 I believe but that is AFAIK more
integrated to the usual namespaces in 2.0.
 
I agree with Patrice's comments but if you're using SqlServer, you can
change the UpdateBatchSize property which can definitely help out
performance - that way , if you're updating 100 rows you can do it in one
trip do the db (or however many trips you want) instead of 100. Just to be
thorough though, I'd check the usual suspects for bottlenecks and make sure
I covered all of those bases too as possible places that are causing my
performance issues.

HTH,

Bill
 
Many thanks guys for all your helpful comments. The data source is
loaded on the client and then transferred to the Server.

The UpdateBatchSize sounds interesting. Is this a new feature?

Geoff
 
Yep - one of the many great ones
Geoff said:
Many thanks guys for all your helpful comments. The data source is
loaded on the client and then transferred to the Server.

The UpdateBatchSize sounds interesting. Is this a new feature?

Geoff
Click to expand...
 
Back
Top