Q: Slow update

Hi All

I hope you'll forgive me for posting this here (I've also posted to ado site
but with no response so far) as I'm urgently after a solution.

Can anybody help me? I'm updating a table on a database i.e. I've modified
the table in a DataSet and I want to update it to the SQL database which the
table originally came from. I'm using a data adaptor and the update command
and it works BUT it is soooooooooo slow!!! Can anybody tell me of any
techniques to speed it up?

Thanks in advance

Geoff


.

Relevant Pages

  • Re: Q: Slow update
    ... I hope you'll forgive me for posting this here (I've also posted to ado site but with no response so far) as I'm urgently after a solution. ... the table in a DataSet and I want to update it to the SQL database which the ...
    (microsoft.public.dotnet.languages.vb)
  • Updating a SQL database
    ... Subject: Updating a SQL database 5/5/2004 10:55 PM PST ... What I have is a form that has text fields populated from a SQL database. ... I'm changing the text in them to trigger a 'change' so the update command will work. ... Hi Amber: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: ADO.NET Update SQL View
    ... Thanks for the response. ... Unfortunately I have tried writing a Stored ... I setup the Update command of my adaptor so that the stroed ... ready to scrap .NET and return to VB6 simply for the data access ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO.NET Update SQL View
    ... Thanks for the response. ... Unfortunately I have tried writing a Stored ... I setup the Update command of my adaptor so that the stroed ... ready to scrap .NET and return to VB6 simply for the data access ...
    (microsoft.public.dotnet.framework.adonet)
  • System.Data.DBConcurrencyException
    ... I am having an intermittent problem in updating a SQL database from a web ... then invoking the Update command in my data adapter. ...
    (microsoft.public.data.ado)